Source Install MySQL5.7.20
Source Install MySQL 5.7.20mysql5.7版本之后要用boost1.59
http://www.boost.org/
yum -y install gcc gcc-c++ ncurses ncurses-devel cmake bison wget
wget https://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz && wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.20.tar.gz
tar xf boost_1_59_0.tar.gz && tar xf mysql-boost-5.7.20.tar.gz
cd mysql-5.7.20
groupadd mysql
useradd mysql -s /bin/nologin -M -g mysql
mkdir -p /usr/local/mysql-5.7.20 /usr/local/mysql-5.7.20/data /usr/local/mysql-5.7.20/mysql.sock
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.7.20\
-DMYSQL_DATADIR=/usr/local/mysql-5.7.20/data \
-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.7.20/mysql.sock \
-DSYSCONFDIR=/etc \
-DWITH_BOOST=../boost_1_59_0 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0
编译安装
make -j `grep processor /proc/cpuinfo | wc -l`
make install
设置启动脚本，开机自启动
ls -lrt /usr/local/mysql
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
配置文件
/etc/my.cnf，
cat > /etc/my.cnf > /etc/profile && source /etc/profile
初始化数据库
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
启动数据库
systemctl start mysqld
systemctl status mysqld
查看MySQL服务进程和端口
ps -ef | grep mysql
设置数据库root用户密码
mysql_secure_installation
常用操作
将MySQL数据库的动态链接库共享至系统链接库
一般MySQL数据库还会被类似于PHP等服务调用，所以我们需要将MySQL编译后的lib库文件添加至当前Linux主机链接库 /etc/ld.so.conf.d/
下，这样MySQL服务就可以被其它服务调用了。
ldconfig |grep mysql
echo "/usr/local/mysql/lib" > /etc/ld.so.conf.d/mysql.conf
ldconfig
ldconfig -v |grep mysql
进入数据库
mysql -uroot -p
show databases;
quit
页:
[1]