mysql学习笔记二之阿里云Mysql8.0平滑升级

1、下载最新版的mysql
2、上传到阿里云服务器
3、解压
前三步参考: mysql学习笔记一之数据库安装

4、停止mysql的运行

systemctl stop mysqld

5、执行mysql安装命令，和安装数据库命令一致

rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.26-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.26-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.26-1.el7.x86_64.rpm --nodeps --force

6、查找已安装的mysql

[root@iZwz9hw4qywrrl4vj6o0j1Z download]# rpm -qa | grep mysql
mysql-community-server-8.0.21-1.el7.x86_64
mysql-community-server-8.0.26-1.el7.x86_64
mysql-community-common-8.0.21-1.el7.x86_64
mysql-community-common-8.0.26-1.el7.x86_64
mysql-community-libs-8.0.21-1.el7.x86_64
mysql-community-libs-8.0.26-1.el7.x86_64
mysql-community-client-8.0.21-1.el7.x86_64
mysql-community-client-8.0.26-1.el7.x86_64

7、删除旧版本的mysql

rpm -e mysql-community-server-8.0.21-1.el7.x86_64
 rpm -e mysql-community-client-8.0.21-1.el7.x86_64
  rpm -e mysql-community-libs-8.0.21-1.el7.x86_64
  rpm -e mysql-community-common-8.0.21-1.el7.x86_64

8、确认是否删除完毕

[root@iZwz9hw4qywrrl4vj6o0j1Z download]# rpm -qa | grep mysql
mysql-community-server-8.0.26-1.el7.x86_64
mysql-community-common-8.0.26-1.el7.x86_64
mysql-community-libs-8.0.26-1.el7.x86_64
mysql-community-client-8.0.26-1.el7.x86_64

9、启动mysql

[root@iZwz9hw4qywrrl4vj6o0j1Z download]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
[root@iZwz9hw4qywrrl4vj6o0j1Z download]# ps -ef|grep mysql
mysql    12686     1 10 16:16 ?        00:00:00 /usr/sbin/mysqld
root     12885 21324  0 16:16 pts/2    00:00:00 grep --color=auto mysql

11、进入mysql查看mysql版本

mysql> \s
--------------
mysql  Ver 8.0.26 for Linux on x86_64 (MySQL Community Server - GPL)

升级完成，纵享丝滑（手动滑稽）。