mysql升级5.7

1. 卸载mysql

sudo yum remove mysql

2. 去除遗留依赖文件

sudo rpm -e --nodeps mysql-libs

3. 安装numa

sudo yum install numa

4. 安装libaio

sudo yum install libaio.x86_64 libaio-devel.x86_64

5. 安装mysql 5.7

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

6. 修改my.cnf

7. 启动mysql

sudo /sbin/service mysqld restart

8. 修改root密码

sudo grep 'temporary password' /var/log/mysqld.log
mysql -uroot -p -h127.0.0.1
ALTER USER 'root'@'localhost' IDENTIFIED BY 'leqVs?1kkG0b';

9. 创建远程使用账号

 CREATE USER 'root'@'%' IDENTIFIED BY 'leqVs?1kkG0b'

10. 建库

CREATE DATABASE jenkinsForTest;
use jenkinsForTest;
GRANT ALL ON jenkinsForTest.* TO 'root'@'%';