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';