1.查看centos版本

uname -a
 age-1725344493122](http://file.zszxc.top/zhaixing/file/image-1725344493122.png)


2、当前mysql版本

mysql -V

3、下载mysql离线安装包

https://dev.mysql.com/downloads/mysql/
1、备份数据库

mysqldump -uroot -p --all-databases >backupall.sql


2、关闭mysql

systemctl stop mysqld


 

3、上传RPM包
安装包解压:

tar -xvf mysql-8.0.35-1.el7.x86_64.rpm-bundle.tar


 4、强制进行数据字典升级和服务升级安装【严格按照此顺序】

rpm -ivh mysql-community-common-8.0.35-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.0.33-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.0.33-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm --nodeps --force




5、查找已安装的mysql

rpm -qa |grep mysql

mysql-community-server-8.0.35-1.el7.x86_64
mysql-community-server-8.0.32-1.el7.x86_64
mysql-community-libs-8.0.35-1.el7.x86_64
mysql-community-common-8.0.32-1.el7.x86_64
mysql-community-icu-data-files-8.0.32-1.el7.x86_64
mysql-community-client-8.0.35-1.el7.x86_64
mysql-community-libs-8.0.32-1.el7.x86_64
mysql-community-client-plugins-8.0.32-1.el7.x86_64
mysql-community-common-8.0.35-1.el7.x86_64
mysql-community-icu-data-files-8.0.35-1.el7.x86_64
mysql-community-client-8.0.32-1.el7.x86_64
mysql-community-client-plugins-8.0.35-1.el7.x86_64

 

6、删除查找到的上个版本的安装包【严格按照此顺序】

rpm -e mysql-community-server-8.0.32-1.el7.x86_64
rpm -e mysql-community-icu-data-files-8.0.32-1.el7.x86_64
rpm -e mysql-community-client-8.0.32-1.el7.x86_64
rpm -e mysql-community-libs-8.0.32-1.el7.x86_64
rpm -e mysql-community-client-plugins-8.0.32-1.el7.x86_64
rpm -e mysql-community-common-8.0.32-1.el7.x86_64

查看最终安装包信息

rpm -qa |grep mysql

 

7、启动mysql

systemctl start mysqld



8、查看是否启动

ps -ef|grep mysql


转载:https://www.cnblogs.com/wqiming/p/17179488.html