centos6.9安装mysql5.7

1、查看系统版本

lsb_release -a

2、卸载old mysql

rpm -qa|grep -i mysql
rpm -ev MySQL-client-5.5.25a-1.rhel5 如果提示依赖错误，增加--nodeps
find / -name mysql
rm -rf /var/lib/mysql
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql
rm -rf /etc/my.cnf
rpm -qa|grep -i mysql

3、下载mysql，如果是centos6系列一定要el6，不然出现glibc安装错误

wget -c https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar 

mysql-community-client-5.7.18-1.el6.x86_64.rpm
mysql-community-common-5.7.18-1.el6.x86_64.rpm
mysql-community-devel-5.7.18-1.el6.x86_64.rpm
mysql-community-embedded-5.7.18-1.el6.x86_64.rpm
mysql-community-embedded-devel-5.7.18-1.el6.x86_64.rpm
mysql-community-libs-5.7.18-1.el6.x86_64.rpm
mysql-community-libs-compat-5.7.18-1.el6.x86_64.rpm
mysql-community-server-5.7.18-1.el6.x86_64.rpm
mysql-community-test-5.7.18-1.el6.x86_64.rpm

4、安装基础包

yum install gcc gcc-c++ ncurses-devel perl

wget http://mirror.centos.org/centos/6/os/x86_64/Packages/numactl-2.0.9-2.el6.x86_64.rpm 
＃这个包在安装server提示libnuma.so.1

5、安装mysql（顺序：common-libs-client-server，里面compat，test，devel，embedded根据需要安装)

rpm -ivh mysql-community-common-5.7.18-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.18-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.18-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.18-1.el6.x86_64.rpm

6、启动服务

service mysqld start

7、查看root 临时密

grep 'temporary password' /var/log/mysqld.log

8、修改root米啊吗

mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

9、远程用户

GRANT ALL PRIVILEGES ON jiebao.* TO 'jiebao'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES 

10、mysql相关文件及路径