Centos下编译安装mysql5.7

很早以前记录过一篇mysql5.6版本的，现在的版本安装有些区别，所以再记录一下。
旧版本地址：Centos下编译mysql5.6.16

下载
https://dev.mysql.com/downloads/mysql/5.7.html#downloads

安装依赖项

yum -y install cmake ncurses ncurses-devel

编译Mysql

cmake . \
-DCMAKE_INSTALL_PREFIX=/data/apps/mysql5.7.25 \
-DMYSQL_DATADIR=/data/mysqldata \
-DSYSCONFDIR=/data/apps/mysql5.7.25/etc \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/data/apps/boost \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1

make && make install

加入到系统服务

cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on

配置&&初始化

groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /data/apps/mysql5.7.25
/data/apps/mysql5.7.25/bin/mysqld --initialize-insecure --user=mysql --basedir=/data/apps/mysql5.7.25 --datadir=/data/mysqldata

启动Mysql

service mysqld start

设置root密码

/data/apps/mysql5.7.25/bin/mysqladmin -uroot password yourpassword