3、useradd -r -g mysql -s /bin/false mysql
4、用cmake编译mysql, 相关参数可以参考https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html，下列参数要写在一行
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DSYSCONFDIR=/usr/local/mysql/etc -DSYSTEMD_PID_DIR=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DWITH_BOOST=boost -DWITH_SYSTEMD=1
5、make && make install
6、配置mysql并初始化数据库
6.1 cd /usr/local/mysql #进入编译目录
6.2 chown -R mysql . #修改目录所有者
6.3 chgrp -R mysql . #修改目录组
6.4 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld #配置mysqld服务
6.5 cp /usr/local/mysql/support-files/my-default.cnf /usr/local/mysql/my.cnf #配置my.cnf
6.5.1 复制以下内容到my.cnf文件中的[mysqld]下
user = mysql basedir = /usr/local/mysql datadir = /usr/local/mysql/data port = 3306 server_id = /usr/local/mysql/mysqld.pid socket = /usr/local/mysql/mysql.sock
6.5 chkconfig mysqld on #设置mysqld开机自启
6.6 bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data #初始化数据库
6.7 bin/mysqld --user=mysql & #启动mysql, 如果报Please read "Security" section of the manual to find out how to run mysqld as root!，就在my.cnf中加入user=root, 表示以root用户启动
7、修改root用户登录密码并允许root用户远程登录
7.1 mysql -u root --skip-password
7.2 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
7.3 允许root用户远程登录
7.3.1 use mysql;
7.3.2 update user set host='%' where user='root' and host='localhost'; #允许 (update user set host='localhost' where user='root'; #禁用)
7.3.3 flush privileges;
7.3.4 service mysqld restart
8、解决service mysqld start|stop报MySQL server PID file could not be found!或者Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)， 其实可通过阅读此文件解决相关错误
8.1 chmod 777 /usr/local/mysql #因我设置mysqld.pid文件保存在/usr/local/mysql目录，所以保证其有可写权限
