mysql5.6小版本升级至5.6.51：rpm包安装升级

mysql升级：rpm包安装升级

一、背景描述

当前版本:Mysql 5.6.30，漏扫有一堆的风险漏洞，需要升级到5.6.51。

二、下载mysql安装包

下载地址：https://downloads.mysql.com/archives/community/
我们这里升级5.6.30到5.6.51，小版本升级。
下载rpm包：https://cdn.mysql.com/archives/mysql-5.6/MySQL-5.6.51-1.el7.x86_64.rpm-bundle.tar

解压缩软件包

[root@localhost opt]# ls
MySQL-5.6.51-1.el7.x86_64.rpm-bundle.tar
[root@localhost opt]# tar -xvf MySQL-5.6.51-1.el7.x86_64.rpm-bundle.tar 
MySQL-client-5.6.51-1.el7.x86_64.rpm
MySQL-devel-5.6.51-1.el7.x86_64.rpm
MySQL-embedded-5.6.51-1.el7.x86_64.rpm
MySQL-server-5.6.51-1.el7.x86_64.rpm
MySQL-shared-5.6.51-1.el7.x86_64.rpm
MySQL-shared-compat-5.6.51-1.el7.x86_64.rpm
MySQL-test-5.6.51-1.el7.x86_64.rpm
[root@localhost opt]# ls -l
total 496768
-rw-r--r-- 1 root root  254341120 Apr 14 14:36 MySQL-5.6.51-1.el7.x86_64.rpm-bundle.tar
-rw-r--r-- 1 7155 31415  21606520 Jan  5  2021 MySQL-client-5.6.51-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   3536604 Jan  5  2021 MySQL-devel-5.6.51-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  93754464 Jan  5  2021 MySQL-embedded-5.6.51-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  70091008 Jan  5  2021 MySQL-server-5.6.51-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   2338300 Jan  5  2021 MySQL-shared-5.6.51-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   2299660 Jan  5  2021 MySQL-shared-compat-5.6.51-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  60704356 Jan  5  2021 MySQL-test-5.6.51-1.el7.x86_64.rpm

三、升级mysql

注：升级前先备份数据库数据，升级前停止Mysql服务：systemctl stop mysql

①、rpm Uvh 软件包升级。

rpm -Uvh MySQL-client-5.6.51-1.el7.x86_64.rpm
rpm -Uvh MySQL-devel-5.6.51-1.el7.x86_64.rpm
rpm -Uvh MySQL-embedded-5.6.51-1.el7.x86_64.rpm
rpm -Uvh MySQL-server-5.6.51-1.el7.x86_64.rpm
rpm -Uvh MySQL-shared-5.6.51-1.el7.x86_64.rpm
rpm -Uvh MySQL-shared-compat-5.6.51-1.el7.x86_64.rpm
rpm -Uvh MySQL-test-5.6.51-1.el7.x86_64.rpm

②、强制替换。
注：升级安装时提示文件已存在，使用–replacefiles 进行强制替换

rpm -Uvh MySQL-client-5.6.51-1.el7.x86_64.rpm --replacefiles 
rpm -Uvh MySQL-server-5.6.51-1.el7.x86_64.rpm --replacefiles 

升级完成后启动服务：systemctl start mysql

mysql -V 查看Mysql版本。

mysql 数据库小版本5.7.22升级至5.7.37 参考：https://blog.csdn.net/guozai0904/article/details/125674470