mysql5.7 编译安装

一、依赖安装

yum install -y wget cmake make bison bison-devel libaio-devel gcc gcc-c++ git ncurses-devel

二、创建运行用户和环境目录

useradd -s /sbin/nologin -d /usr/local/mysql mysql
mkdir -p /data/mysql
chown mysql.mysql /data/mysql -R

三、源码和boots下载

https://sourceforge.net/projects/boost/files/boost/1.59.0/

https://dev.mysql.com/downloads/mysql/

四、编译参数

cmake .  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql/data   -DSYSCONFDIR=/usr/local/mysql/etc  -DDOWNLOAD_BOOST=1  -DWITH_BOOST=/usr/local/boost  -DWITH_INNOBASE_STORAGE_ENGINE=1  -DWITH_PARTITION_STORAGE_ENGINE=1  -DWITH_FEDERATED_STORAGE_ENGINE=1  -DWITH_BLACKHOLE_STORAGE_ENGINE=1  -DWITH_MYISAM_STORAGE_ENGINE=1  -DENABLED_LOCAL_INFILE=1  -DENABLE_DTRACE=0  -DDEFAULT_CHARSET=utf8mb4  -DDEFAULT_COLLATION=utf8mb4_general_ci  -DWITH_EMBEDDED_SERVER=1