1.1 确认版本信息
rpm -qa|grep mysql mysql -V
如图:
[root@vpswhw2-wonders-zy ~]# rpm -qa|grep mysql mysql-community-common-8.0.24-1.el7.x86_64 mysql-community-client-8.0.24-1.el7.x86_64 mysql-community-server-8.0.24-1.el7.x86_64 mysql-community-client-plugins-8.0.24-1.el7.x86_64 mysql-community-libs-8.0.24-1.el7.x86_64 [root@vpswhw2-wonders-zy ~]# mysql -V mysql Ver 8.0.24 for Linux on x86_64 (MySQL Community Server - GPL) [root@vpswhw2-wonders-zy ~]#
1.2 下载安装包
MySQL :: Download MySQL Community Server
MySQL :: Download MySQL Community Server
以升级8.0.24为例,下载mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar
1.3 解压安装包文件
tar -xvf mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar
[root@vpswhw2-wonders-zy tools]# tar -xvf mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar mysql-community-client-8.3.0-1.el7.x86_64.rpm mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm mysql-community-common-8.3.0-1.el7.x86_64.rpm mysql-community-debuginfo-8.3.0-1.el7.x86_64.rpm mysql-community-devel-8.3.0-1.el7.x86_64.rpm mysql-community-embedded-compat-8.3.0-1.el7.x86_64.rpm mysql-community-icu-data-files-8.3.0-1.el7.x86_64.rpm mysql-community-libs-8.3.0-1.el7.x86_64.rpm mysql-community-libs-compat-8.3.0-1.el7.x86_64.rpm mysql-community-server-8.3.0-1.el7.x86_64.rpm mysql-community-server-debug-8.3.0-1.el7.x86_64.rpm mysql-community-test-8.3.0-1.el7.x86_64.rpm [root@vpswhw2-wonders-zy tools]# ll ▒▒▒▒▒ 2865412 -rw-r--r-- 1 root root 1069373440 2▒▒ 19 14:20 mysql-8.3.0-1.el7.x86_64.rpm-bundle.tar -rw-r--r-- 1 7155 31415 17008176 12▒▒ 15 18:03 mysql-community-client-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 3623692 12▒▒ 15 18:04 mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 698240 12▒▒ 15 18:04 mysql-community-common-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 563964668 12▒▒ 15 18:04 mysql-community-debuginfo-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 2015760 12▒▒ 15 18:04 mysql-community-devel-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 4217684 12▒▒ 15 18:04 mysql-community-embedded-compat-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 2344976 12▒▒ 15 18:04 mysql-community-icu-data-files-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 1587092 12▒▒ 15 18:04 mysql-community-libs-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 685936 12▒▒ 15 18:04 mysql-community-libs-compat-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 68000076 12▒▒ 15 18:05 mysql-community-server-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 26362656 12▒▒ 15 18:05 mysql-community-server-debug-8.3.0-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 378844364 12▒▒ 15 18:06 mysql-community-test-8.3.0-1.el7.x86_64.rpm
1.4 逻辑备份数据库
mysqldump -u root -h host -p --all-databases > /data/backdb.sql
1.5 停止数据库服务
service mysqld stop
systemctl stop mysqld
1.6 备份数据库配置文件及数据文件
a、/etc/my.cnf(默认位置) 配置文件
b、/var/lib/mysql(默认位置) 数据文件,具体位置见配置文件
1.7 升级安装
rpm -ivh mysql-community-common-8.3.0-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-8.3.0-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-8.3.0-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.3.0-1.el7.x86_64.rpm --nodeps --force
[root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-common-8.3.0-1.el7.x86_64.rpm --nodeps --force ▒▒▒棺mysql-community-common-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY ▒▒▒▒... ################################# [100%] ▒▒▒▒▒▒/▒▒װ... 1:mysql-community-common-8.3.0-1.el################################# [100%] [root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-libs-8.3.0-1.el7.x86_64.rpm --nodeps --force ▒▒▒棺mysql-community-libs-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY ▒▒▒▒... ################################# [100%] ▒▒▒▒▒▒/▒▒װ... 1:mysql-community-libs-8.3.0-1.el7 ################################# [100%] [root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-client-8.3.0-1.el7.x86_64.rpm --nodeps --force ▒▒▒棺mysql-community-client-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY ▒▒▒▒... ################################# [100%] ▒▒▒▒▒▒/▒▒װ... 1:mysql-community-client-8.3.0-1.el################################# [100%] [root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm --nodeps --force ▒▒▒棺mysql-community-client-plugins-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY ▒▒▒▒... ################################# [100%] ▒▒▒▒▒▒/▒▒װ... 1:mysql-community-client-plugins-8.################################# [100%] [root@vpswhw2-wonders-zy mysql8.3]# rpm -ivh mysql-community-server-8.3.0-1.el7.x86_64.rpm --nodeps --force ▒▒▒棺mysql-community-server-8.3.0-1.el7.x86_64.rpm: ͷV4 RSA/SHA256 Signature, ▒▒Կ ID a8d3785c: NOKEY ▒▒▒▒... ################################# [100%] ▒▒▒▒▒▒/▒▒װ... 1:mysql-community-server-8.3.0-1.el################################# [100%] [root@vpswhw2-wonders-zy mysql8.3]#
1.8 卸载原版本
rpm -qa | grep mysql
rpm -e mysql-community-server-8.0.24-1.el7.x86_64
rpm -e mysql-community-client-8.0.24-1.el7.x86_64
rpm -e mysql-community-libs-8.0.24-1.el7.x86_64
rpm -e mysql-community-common-8.0.24-1.el7.x86_64
rpm -e mysql-community-client-plugins-8.0.24-1.el7.x86_64
[root@vpswhw2-wonders-zy mysql8.3]# rpm -qa | grep mysql mysql-community-common-8.0.24-1.el7.x86_64 mysql-community-common-8.3.0-1.el7.x86_64 mysql-community-client-8.0.24-1.el7.x86_64 mysql-community-server-8.0.24-1.el7.x86_64 mysql-community-server-8.3.0-1.el7.x86_64 mysql-community-libs-8.3.0-1.el7.x86_64 mysql-community-client-plugins-8.0.24-1.el7.x86_64 mysql-community-libs-8.0.24-1.el7.x86_64 mysql-community-client-plugins-8.3.0-1.el7.x86_64 mysql-community-client-8.3.0-1.el7.x86_64 [root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-server-8.0.24-1.el7.x86_64 [root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-client-8.0.24-1.el7.x86_64 [root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-client-plugins-8.0.24-1.el7.x86_64 ▒▒▒▒▒▒▒▒▒▒ʧ▒ܣ▒ mysql-community-client-plugins = 8.0.24-1.el7 ▒▒ (▒Ѱ▒?) mysql-community-libs-8.0.24-1.el7.x86_64 ▒▒Ҫ [root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-libs-8.0.24-1.el7.x86_64 [root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-common-8.0.24-1.el7.x86_64 [root@vpswhw2-wonders-zy mysql8.3]# rpm -qa|grep mysql mysql-community-common-8.3.0-1.el7.x86_64 mysql-community-server-8.3.0-1.el7.x86_64 mysql-community-libs-8.3.0-1.el7.x86_64 mysql-community-client-plugins-8.0.24-1.el7.x86_64 mysql-community-client-plugins-8.3.0-1.el7.x86_64 mysql-community-client-8.3.0-1.el7.x86_64 [root@vpswhw2-wonders-zy mysql8.3]# rpm -e mysql-community-client-plugins-8.0.24-1.el7.x86_64 [root@vpswhw2-wonders-zy mysql8.3]# rpm -qa|grep mysql mysql-community-common-8.3.0-1.el7.x86_64 mysql-community-server-8.3.0-1.el7.x86_64 mysql-community-libs-8.3.0-1.el7.x86_64 mysql-community-client-plugins-8.3.0-1.el7.x86_64 mysql-community-client-8.3.0-1.el7.x86_64 [root@vpswhw2-wonders-zy mysql8.3]#
1.9 启动数据库
systemctl start mysqld
systemctl status mysqld
[root@vpswhw2-wonders-zy mysql8.3]# systemctl start mysqld [root@vpswhw2-wonders-zy mysql8.3]# systemctl status mysqld * mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since һ 2024-02-19 15:16:07 CST; 48s ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 38367 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 38416 (mysqld) Status: "Server is operational" Tasks: 38 Memory: 609.8M CGroup: /system.slice/mysqld.service `-38416 /usr/sbin/mysqld 2▒▒ 19 15:15:30 vpswhw2-wonders-zy systemd[1]: Starting MySQL Server... 2▒▒ 19 15:16:07 vpswhw2-wonders-zy systemd[1]: Started MySQL Server. [root@vpswhw2-wonders-zy mysql8.3]#
2.0 确认新版本信息和数据完整性
[root@vpswhw2-wonders-zy mysql8.3]# mysql -V mysql Ver 8.3.0 for Linux on x86_64 (MySQL Community Server - GPL) [root@vpswhw2-wonders-zy mysql8.3]#
至此,升级完成。