• 安裝依賴

yum -y install gcc gcc-c++ cmake ncurses-devel bison

• 創(chuàng)建 Mysql 用戶及組

groupadd mysql

useradd mysql -g mysql -s /sbin/nologin -M

• 下載 mysql-boost 安裝包

mkdir -p /usr/local/src/download/mysql5.7

cd /usr/local/src/download/mysql5.7

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.25.tar.gz

• 解壓 mysql-boost

tar zxvf mysql-boost-5.7.25.tar.gz

• 創(chuàng)建數(shù)據(jù)庫數(shù)據(jù)存放目錄

mkdir -p /usr/local/mysql5.7/data

• 創(chuàng)建數(shù)據(jù)庫日志文件

mkdir -p /usr/local/mysql5.7/log

touch /usr/local/mysql5.7/log/error.log

• 創(chuàng)建數(shù)據(jù)庫 pid 文件存放目錄

mkdir -p /usr/local/mysql5.7/run

• 調整 mysql 目錄權限

chown -R mysql:mysql /usr/local/mysql5.7

• 安裝 Mysql5.7

cd mysql-5.7.25

cmake -DMYSQL_USER=mysql\
 -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.7\
 -DINSTALL_DATADIR=/usr/local/mysql5.7/data\
 -DMYSQL_UNIX_ADDR=/usr/local/mysql5.7/tmp/mysqld.sock\
 -DDEFAULT_CHARSET=utf8\
 -DDEFAULT_COLLATION=utf8_general_ci\
 -DEXTRA_CHARSETS=all\
 -DWITH_EMBEDDED_SERVER=1\
 -DENABLED_LOCAL_INFILE=1\
 -DWITH_MYISAM_STORAGE_ENGINE=1\
 -DWITH_INNOBASE_STORAGE_ENGINE=1\
 -DDOWNLOAD_BOOST=1\
 -DWITH_BOOST=./boost

make

make install

• mysql 配置文件

vi /etc/my.cnf

[client]
port = 3306
socket = /usr/local/mysql5.7/run/mysql.sock

[mysqld]
basedir = /usr/local/mysql5.7
datadir = /usr/local/mysql5.7/data
socket = /usr/local/mysql5.7/run/mysql.sock

[mysqld_safe]
log-error =  /usr/local/mysql5.7/log/error.log
pid-file = /usr/local/mysql5.7/run/mysql.pid

• mysql 啟動腳本

cp mysql.server /etc/init.d/mysqld

chmod a+x /etc/init.d/mysqld

chkconfig --level 345 mysqld on

• 環(huán)境變量

echo "export PATH=/usr/local/mysql5.7/bin:$PATH" >> /etc/profile

source /etc/profile

• 初始化 mysql，得到 root 用戶的初始密碼

/usr/local/mysql5.7/bin/mysqld --initialize\
 --basedir=/usr/local/mysql5.7\
 --datadir=/usr/local/mysql5.7/data\
 --user=mysql

• 啟動 mysql 服務

/etc/init.d/mysqld start

• 修改 root 用戶密碼

/usr/local/mysql5.7/bin/mysql -uroot -p

alter user 'root'@'localhost' identified by '123456';