1. 创建MySQL用户

groupadd -g 27 mysql
useradd -u 27 -g mysql -s /sbin/nologin -M mysql

1.1.1. 安装/确认基础软件

yum install -y make cmake gcc gcc-c++ ncurses-devel bison >/dev/null 2>&1

1.1.2. 判断CMakeCache.txt文件是否存在

如果存在说明曾经cmake过，需要删除

1.1.3. 指定编译参数

cmake -LH 产生CMakeCache.txt, make就按这个cache文件来编译

cmake \
-DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql \
-DMYSQL_DATADIR:PATH=/database \
-DSYSCONFDIR:PATH=/usr/local/mysql/etc \
-DWITH_DEBUG:BOOL=on

1.1.4. 编译并安装

make && make install

1.1.5. 创建配置文件目录

mkdir /usr/local/mysql/etc

1.1.6. 生成配置文件

cat /usr/local/mysql/etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/database
socket=/var/run/mysqld/mysql.sock
pid-file=/var/run/mysqld/mysql.pid
port=3306
user=mysql

[mysqld_safe]
log-error=/var/log/mysqld/mysql5.6-error.log

1.1.7. 给予相关目录权限

mkdir /database /var/run/mysqld /var/log/mysqld
chown -R mysql.mysql /usr/local/mysql /database /var/run/mysqld /var/log/mysqld  

1.1.8. 执行安装的脚本

/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/database --user=mysql

1.1.9. 复制启动文件

cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql

1.1.10. 配置开机启动和启动服务

chkconfig --add mysql5.6
service mysql5.6 start

1.1.11. 登录MySQL

mysql -S /var/run/mysql.sock