1.下载新版本
|
1 |
[root@db02 ~]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz |
2.解压
|
1 |
[root@db02 ~]# tar xf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz |
3.移动到指定目录
|
1 |
[root@db02 ~]# mv mysql-5.7.20-linux-glibc2.12-x86_64 /usr/local/mysql-5.7.20 |
4.停止数据库
|
1 |
[root@db02 ~]# systemctl stop mysqld |
5.删除软连接
|
1 |
[root@db02 ~]# rm -rf /usr/local/mysql |
6.添加软连接
|
1 |
[root@db02 ~]# ln -s /usr/local/mysql-5.7.20 /usr/local/mysql |
7.拷贝数据路径与授权
|
1 2 |
[root@db02 ~]# cp -a /usr/local/mysql-5.6.42/data /usr/local/mysql-5.7.20/ [root@db02 ~]# chown -R mysql.mysql /usr/local/mysql-5.7.20 |
8.启动MySQL并更新系统库
|
1 2 |
[root@db02 ~]# systemctl start mysqld [root@db02 ~]# mysql_upgrade |
9.重启MySQL服务
|
1 |
[root@db02 ~]# systemctl restart mysqld |
10.检查MySQL版本
|
1 |
[root@db02 ~]# mysql -e "select @@version;" |
