centos7源码安装mysql5.7

1.基础环境
$ yum install gcc gcc-c++ 
$ yum install ncurses ncurses-devel 
$ yum install bison libgcrypt perl cmake

2.创建用户
$ cat /etc/group | grep mysql     //查看是否存在mysql用户组
$ cat /etc/passwd | grep mysql    //查看是否存在mysql用户
$ groupadd mysql                  //创建用户组
$ useradd -r -g mysql mysql       //创建用户

3.创建目录,并赋予权限
$ mkdir /usr/local/mysql
$ mkdir /usr/local/mysql/data
$ mkdir /usr/local/mysql/logs
$ mkdir /usr/local/mysql/pids
$ chown -R mysql:mysql /usr/local/mysql

4.mysql5.7源码编译需要boost库支持
4.1 检查和卸载已存在的boost库
$ rpm -qa | grep boost
$ yum -y remove boost-*
4.2 下载boost库，指定要1.59版本
$ wget -S https://jaist.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.zip
4.3 解压库 
$ mkdir /usr/local/boost
$ unzip boost_1_59_0.zip
$ mv boost_1_59_0 /usr/local/boost/

5.下载mysql5.7源码包
wget -S http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17.tar.gz

6.编译，会比较漫长
$ tar xvf mysql-5.7.17.tar.gz
$ cd mysql-5.7.17
$ cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_USER=mysql \
-DWITH_BOOST=/usr/local/boost/boost_1_59_0
$ make
$ make install

7.编辑配置文件my.cnf
$ mv /etc/my.cnf /etc/my.cnf.bak
$ cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
$ vim /etc/my.cnf
内容如下：

[mysqld]
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
log-error=/usr/local/mysql/logs/mysqld.log
pid-file=/usr/local/mysql/pids/mysqld.pid

如果有，删除这一行

# sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

8.初始化
$ cd /usr/local/mysql
$ bin/mysqld --defaults-file=/etc/my.cnf --initialize-insecure --user=mysql
$ ls data

9.配置启动服务与设置开机启动
$ cd /usr/local/mysql
$ cp support-files/mysql.server /etc/init.d/mysqld
$ chmod a+x /etc/init.d/mysqld

$ chkconfig --list
$ chkconfig --add mysqld
$ chkconfig mysqld on
$ chkconfig --list

10.设置mysql的环境变量
$ vim /etc/profile
输入内容：

#mysql path
export PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH

使环境变量生效：
$ source /etc/profile

11.控制mysql
$ service mysqld start //启动
$ service mysqld restart //重启
$ service mysqld stop //停止

12.启动mysql后，设置mysql初始密码，只允许root在本机执行
$ mysql -uroot -h127.0.0.1
$ use mysql;
$ update user set authentication_string=password('root') where user='root' and Host='localhost';
$ FLUSH PRIVILEGES;

13.查看与设置防火墙
查看防火墙：
$ firewall-cmd --list-port
$ firewall-cmd --zone=public --list-ports

开放防火墙端口：
$ firewall-cmd --zone=public --add-port=3306/tcp --permanent
$ firewall-cmd --reload

14.新增用户，如有需要
$ GRANT select, insert, update, delete, create, drop, alter ON *.* TO 'daiyu'@'%' IDENTIFIED BY 'daiyu' WITH GRANT OPTION;
$ FLUSH PRIVILEGES;

参考官网教程：https://dev.mysql.com/doc/refman/5.7/en/source-installation.html

原文出自：http://blog.csdn.net/daiyudong2020/article/details/56307532

End;