Mysql5.7.16安裝過程

1.安裝依賴包

1 yum -y install gcc-c++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison

2、安裝boost庫（對應版本高於或低於這個版本都有問題)

1 wget http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
2 
3 tar zxvf  boost_1_59_0.tar.gz 
4 mv boost_1_59_0 /usr/local/boost

3、添加mysql用戶組

1 groupadd mysql
2 useradd -r -g mysql -s /sbin/nologin mysql

4、下載mysql源碼包並安裝

1 wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.16.tar.gz
2 
3 tar zxvf mysql-5.7.16.tar.gz
4 cd mysql-5.7.16
5 cmake -DCMAKE_INSTALL_PREFIX=/home/mysql -DMYSQL_DATADIR=/home/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost
6 make && make install

5.調整配置文件

1 mv /etc/my.cnf /etc/my.cnf.bak
2 cp /home/mysql/support-files/my-default.cnf /etc/my.cnf

6. 給安裝目錄設置許可權

1 chown -R mysql:mysql /home/mysql

7.初始化資料庫

1 /home/mysql/mysqld --initialize --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data

註：初始化後會生成預設密碼，請記錄下來
2016-02-17T03:16:36.869627Z 1 [Note] A temporary password is generated for root@localhost: kci!&lc?s8wE

8.啟動mysql

1 cp /home/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
2 chmod +x /etc/rc.d/init.d/mysqld
3 chkconfig --add /etc/rc.d/init.d/mysqld
　service mysqld start

9、訪問資料庫

1 mysql -uroot -p

10、修改預設密碼（不修改預設密碼，將不能正常使用sql，必須修改）

1 alter user 'root'@'localhost' identified by '123456';