mysql升级到5.7.20_mysql版本升级(5.7.30到8.0.20)

1.下载官方提供的检测工具

8.0版本之后都有提供,要升级成哪个小版本,就下载哪个小版本对应的工具

(1)解压工具包

[root@mysql01 /opt/mysql]# tar xf mysql-shell-8.0.20-linux-glibc2.12-x86-64bit.tar.gz

[root@mysql01 /opt/mysql]# ls

mysql-5.6.46-linux-glibc2.12-x86_64 mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz mysql-shell-8.0.20-linux-glibc2.12-x86-64bit

mysql-5.7.30-linux-glibc2.12-x86_64 mysql-shell-8.0.20-linux-glibc2.12-x86-64bit.tar.gz

(2)创建软链接

[root@mysql01 /opt/mysql]# ln -s /opt/mysql/mysql-shell-8.0.20-linux-glibc2.12-x86-64bit /usr/local/mysqlsh

[root@mysql01 /opt/mysql]# cd /usr/local/mysqlsh/

[root@mysql01 /usr/local/mysqlsh]# ls

bin lib share

(3) 将脚本声明到环境变量方便直接调用

[root@mysql01 /usr/local/mysqlsh]# vim /etc/profile

export PATH=/usr/local/mysqlsh/bin:$PATH

[root@mysql01 /usr/local/mysqlsh]# source /etc/profile

[root@mysql01 /usr/local/mysqlsh]# mysqlsh --version

mysqlsh Ver 8.0.20 for Linux on x86_64 - for MySQL 8.0.20 (MySQL Community Server (GPL))

2.进入5.7版本的实列创建用于远程连接的用户

#使用工具脚本检测时需要用到远程用户

[root@mysql01 /usr/local/mysqlsh]# mysql -S /tmp/mysql3357.sock

Welcome to the MySQ