Detailed explanation of how to install mysql5.7.16 from source code in centos7 environment

> useradd -s /sbin/nologin mysql

> mkdir /data/mysql

> chown -R mysql:mysql /data/mysql

> yum install gcc gcc-c++ cmake bison-devel ncurses-devel libaio libaio-devel

> yum install boost boost-devel

> tar -xf mysql-5.7.16.tar.gz

> cd /data/mysql-5.7.16
>cmake \
-DMYSQL_USER=mysql \
-DCMAKE_INSTALL_PREFIX=/data/mysql \
-DMYSQL_DATADIR=/data/mysql/data \
-DSYSCONFDIR=/data/mysql \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DINSTALL_PLUGINDIR=/data/mysql/plugin \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/boost

#mysql username -DMYSQL_USER=mysql
#Installation path -DCMAKE_INSTALL_PREFIX=/data/mysql
#Data file storage location -DMYSQL_DATADIR=/data/mysql/data
#my.cnf path -DSYSCONFDIR=/data/mysql
#Support MyIASM engine - DWITH_MYISAM_STORAGE_ENGINE=1
#Support InnoDB engine - DWITH_INNOBASE_STORAGE_ENGINE=1
#Support Memory Engine - DWITH_MEMORY_STORAGE_ENGINE=1
#Plugin file and configuration path-DINSTALL_PLUGINDIR=/data/mysql/plugin
#Shortcut key function (I haven't used it)
-DWITH_READLINE=1
#Connect to the database socket path -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock
#Port - DMYSQL_TCP_PORT=3306
#Allow importing data from local - DENABLED_LOCAL_INFILE=1
#Install support for database partitioning - DWITH_PARTITION_STORAGE_ENGINE=1
#Install all character sets -DEXTRA_CHARSETS=all
#Default character - DDEFAULT_CHARSET=utf8
#Check character -DDEFAULT_COLLATION=utf8_general_ci
# will automatically download boost
-DDOWNLOAD_BOOST=1
#Specify the boost directory -DWITH_BOOST=/usr/local/boost

> make && make install

> cp /data/mysql/support-files/my-default.cnf /data/mysql/my.cnf

> /data/mysql/bin/mysqld \
--defaults-file=/data/mysql/my.cnf \
--initialize \
--user=mysql \
--basedir=/data/mysql \
--datadir=/data/mysql/data \

> chown -R mysql:mysql /data/mysql

> rm -rf /etc/my.cnf
> vi /data/mysql/my.cnf

[client]
default-character-set = utf8
port = 3306
socket = /data/mysql/mysql.sock
[mysql]
default-character-set = utf8
[mysqld]
skip-name-resolve
basedir = /data/mysql
datadir = /data/mysql/data
port = 3306
server_id = 10
socket = /data/mysql/mysql.sock
character-set-server = utf8
max_connections = 200
default-storage-engine = INNODB
log-bin=mysql-bin

> cp /data/mysql/support-files/mysql.server /etc/init.d/mysqld
> chmod 755 /etc/init.d/mysqld
> chkconfig --add mysqld

> service mysqld start

> echo "export PATH=/data/mysql/bin/:$PATH" >> /etc/profile
> source /etc/profile

>mysql -uroot -p
> set password=password('123456');
> alter user 'root'@'localhost' password expire never;
> flush privileges;