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