1、安装依赖

yum -y install gcc gcc-c++ ncurses ncurses-devel bison libgcrypt perl make cmake

2、添加mysql用户

useradd -s /sbin/nologin -M mysql

3、下载boost解压到相应目录

mkdir -p  /usr/local/boost
cd  /usr/local/boost
wget https://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
tar xf boost_1_59_0.tar.gz

4、下载mysql-5.7.22.tar.gz并解压

从官网下载即可。

5、创建相应目录

mkdir -p /home/deploy/mysql/{data,log,tmp}
ls /home/deploy/mysql/
chown -R mysql:mysql /home/deploy/mysql/

6、安装

cmake . -DCMAKE_INSTALL_PREFIX=/home/deploy/mysql \
-DMYSQL_DATADIR=/home/deploy/mysql/data \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_USER=mysql \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DENABLE_DOWNLOADS=1 \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/boost

然后make，再继续make install

make && make install

时间比较久，大概需要两个小时

7、添加环境变量

echo 'export PATH=/home/deploy/mysql/bin:$PATH' >>/etc/profile
source  /etc/profile

8、复制mysql启动文件，及配置文件

cp support-files/mysql.server /etc/init.d/mysqld
chmod a+x /etc/init.d/mysqld
cp packaging/rpm-common/my.cnf /etc/my.cnf

9、优化修改my.cnf配置文件

见附件。

10、初始化数据库

mysqld --defaults-file=/etc/my.cnf  --initialize --user='mysql' --log_error_verbosity --explicit_defaults_for_timestamp

11、启动数据库

/etc/init.d/mysqld start
#密码在err_mysql.log中
grep password err_mysql.log 
2019-09-12T10:35:26.035824Z 1 [Note] A temporary password is generated for root@localhost: owsLRUcc.7FL

12、修改密码及授权

修改root密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Tom579#$%^&';

授权root远程登录

GRANT ALL PRIVILEGES ON *.* TO root@'192.168.0.%' IDENTIFIED BY '123456'  WITH GRANT OPTION;

 刷新权限

flush privileges;