1.查看centos版本

uname -a

image-1699411884907
2、当前mysql版本

mysql -V

image-1699412019968
3、下载mysql离线安装包

https://dev.mysql.com/downloads/mysql/
image-1699412068956

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 

image-1699412227199

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

image-1699412427176

7、启动mysql

 systemctl start mysqld

8、查看是否启动

ps -ef|grep mysql

9、登录数据库查看版本
image-1699412528441

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

上一篇 下一篇