Centos系统MySQL5.7版本升级

yongjiu2000

已于 2025-02-07 15:51:25 修改

阅读量676

点赞数 7

CC 4.0 BY-SA版权

分类专栏： MySQL数据库文章标签： centos linux 运维 mysql

于 2025-02-07 15:47:02 首次发布

本文链接：https://blog.youkuaiyun.com/yongjiu2000/article/details/145496652

MySQL数据库专栏收录该内容

10 篇文章

订阅专栏

连接主机...
连接主机成功
Last login: Mon Aug 8 13:06:27 2022 from 10.60.37.112
[root@node4 ~]#
[root@node4 ~]#
# 查看数据库版本
[root@node4 ~]# mysql -V
mysql Ver 14.14 Distrib 5.7.35, for Linux (x86_64) using EditLine wrapper
[root@node4 ~]#
[root@node4 ~]#
# 查看安装组件
[root@node4 ~]# rpm -qa|grep ^mysql-community
mysql-community-common-5.7.35-1.el7.x86_64
mysql-community-libs-compat-5.7.35-1.el7.x86_64
mysql-community-libs-5.7.35-1.el7.x86_64
mysql-community-server-5.7.35-1.el7.x86_64
mysql-community-client-5.7.35-1.el7.x86_64
[root@node4 ~]#
[root@node4 ~]#
# 下载yum源
[root@node4 ~]#
[root@node4 ~]# cd /home
[root@node4 home]#
[root@node4 home]# wget 'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'
--2022-08-08 15:09:24-- https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
正在解析主机 dev.mysql.com (dev.mysql.com)... 23.2.135.207, 2600:140b:2:99c::2e31, 2600:140b:2:99d::2e31
正在连接 dev.mysql.com (dev.mysql.com)|23.2.135.207|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 302 Moved Temporarily
位置：https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm [跟随至新的 URL]
--2022-08-08 15:09:24-- https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
正在解析主机 repo.mysql.com (repo.mysql.com)... 184.30.152.230
正在连接 repo.mysql.com (repo.mysql.com)|184.30.152.230|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 200 OK
长度：25680 (25K) [application/x-redhat-package-manager]
正在保存至: “mysql57-community-release-el7-11.noarch.rpm”

100%[===============================================================================================================================================================>] 25,680 --.-K/s 用时 0s

2022-08-08 15:09:25 (339 MB/s) - 已保存 “mysql57-community-release-el7-11.noarch.rpm” [25680/25680])

# 安装yum源
[root@node4 home]#
[root@node4 home]#
[root@node4 home]# rpm -Uvh mysql57-community-release-el7-11.noarch.rpm
准备中... ################################# [100%]
正在升级/安装...
1:mysql57-community-release-el7-11 ################################# [100%]
[root@node4 home]#
[root@node4 home]#
[root@node4 home]#
# 查看mysql yum源
[root@node4 home]# yum repolist|grep mysql
Repository base is listed more than once in the configuration
mysql-connectors-community/x86_64 MySQL Connectors Community 199
mysql-tools-community/x86_64 MySQL Tools Community 92
mysql57-community/x86_64 MySQL 5.7 Community Server 604
[root@node4 home]#
[root@node4 home]#
# 停止mysql服务
[root@node4 home]# systemctl stop mysqld
[root@node4 home]#
# 升级mysql client
[root@node4 home]# yum update mysql
已加载插件：fastestmirror, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Repository base is listed more than once in the configuration
Determining fastest mirrors
* base: mirrors.aliyun.com
* extras: mirrors.ustc.edu.cn
* updates: mirrors.ustc.edu.cn
base | 3.6 kB 00:00:00
docker-ce-stable | 3.5 kB 00:00:00
epel | 4.7 kB 00:00:00
extras | 2.9 kB 00:00:00
jenkins | 2.9 kB 00:00:00
mysql-connectors-community | 2.6 kB 00:00:01
mysql-tools-community | 2.6 kB 00:00:00
mysql57-community | 2.6 kB 00:00:00
updates | 2.9 kB 00:00:00
(1/7): epel/x86_64/group_gz | 97 kB 00:00:00
(2/7): mysql-connectors-community/x86_64/primary_db | 90 kB 00:00:00
(3/7): mysql-tools-community/x86_64/primary_db | 87 kB 00:00:01
(4/7): mysql57-community/x86_64/primary_db | 315 kB 00:00:02
(5/7): epel/x86_64/updateinfo | 1.0 MB 00:00:03
(6/7): epel/x86_64/primary_db | 7.0 MB 00:00:27
(7/7): updates/7/x86_64/primary_db | 16 MB 00:01:00
正在解决依赖关系
--> 正在检查事务
---> 软件包 mysql-community-client.x86_64.0.5.7.35-1.el7 将被升级
---> 软件包 mysql-community-client.x86_64.0.5.7.39-1.el7 将被更新
--> 解决依赖关系完成

依赖关系解决

=========================================================================================================================================================================================================
Package 架构版本源大小
=========================================================================================================================================================================================================
正在更新:
mysql-community-client x86_64 5.7.39-1.el7 mysql57-community 28 M

事务概要
=========================================================================================================================================================================================================
升级 1 软件包

总下载量：28 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
警告：/var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-client-5.7.39-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY=========== ] 1.9 MB/s | 28 MB 00:00:00 ETA
mysql-community-client-5.7.39-1.el7.x86_64.rpm 的公钥尚未安装
mysql-community-client-5.7.39-1.el7.x86_64.rpm | 28 MB 00:00:17
从 file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 检索密钥

源 "MySQL 5.7 Community Server" 的 GPG 密钥已安装，但是不适用于此软件包。请检查源的公钥 URL 是否配置正确。

失败的软件包是：mysql-community-client-5.7.39-1.el7.x86_64
GPG 密钥配置为：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[root@node4 home]#
[root@node4 home]#
# 升级失败
[root@node4 home]#
[root@node4 home]#
# 升级mysql-server
[root@node4 home]# yum update mysql-server
已加载插件：fastestmirror, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Repository base is listed more than once in the configuration
Loading mirror speeds from cached hostfile
* base: mirrors.aliyun.com
* extras: mirrors.ustc.edu.cn
* updates: mirrors.ustc.edu.cn
正在解决依赖关系
--> 正在检查事务
---> 软件包 mysql-community-server.x86_64.0.5.7.35-1.el7 将被升级
---> 软件包 mysql-community-server.x86_64.0.5.7.39-1.el7 将被更新
--> 正在处理依赖关系 mysql-community-common(x86-64) = 5.7.39-1.el7，它被软件包 mysql-community-server-5.7.39-1.el7.x86_64 需要
--> 正在检查事务
---> 软件包 mysql-community-common.x86_64.0.5.7.35-1.el7 将被升级
---> 软件包 mysql-community-common.x86_64.0.5.7.39-1.el7 将被更新
--> 解决依赖关系完成

依赖关系解决

总下载量：178 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
警告：/var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.39-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY ] 125 kB/s | 232 kB 00:24:14 ETA
mysql-community-common-5.7.39-1.el7.x86_64.rpm 的公钥尚未安装
(1/2): mysql-community-common-5.7.39-1.el7.x86_64.rpm | 311 kB 00:00:01
(2/2): mysql-community-server-5.7.39-1.el7.x86_64.rpm | 178 MB 00:01:29
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
总计 2.0 MB/s | 178 MB 00:01:29
从 file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 检索密钥

源 "MySQL 5.7 Community Server" 的 GPG 密钥已安装，但是不适用于此软件包。请检查源的公钥 URL 是否配置正确。

失败的软件包是：mysql-community-common-5.7.39-1.el7.x86_64
GPG 密钥配置为：file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[root@node4 home]#
# 升级失败
[root@node4 home]#
[root@node4 home]#
# 查看版本
[root@node4 home]# mysql -V
mysql Ver 14.14 Distrib 5.7.35, for Linux (x86_64) using EditLine wrapper
[root@node4 home]#
# 升级签名
[root@node4 home]# rpm --checksig package_name.rpm
错误：package_name.rpm: 打开失败：没有那个文件或目录
[root@node4 home]#
[root@node4 home]# rpm --checksig mysql-community-server-5.7.39-1.el8.x86_64.rpm
错误：mysql-community-server-5.7.39-1.el8.x86_64.rpm: 打开失败：没有那个文件或目录
[root@node4 home]#
[root@node4 home]# gpg --export -a 3a79bd29 > 3a79bd29.asc
gpg: 已创建目录‘/root/.gnupg’
gpg: 新的配置文件‘/root/.gnupg/gpg.conf’已建立
gpg: 警告：在‘/root/.gnupg/gpg.conf’里的选项于此次运行期间未被使用
gpg: 钥匙环‘/root/.gnupg/secring.gpg’已建立
gpg: 钥匙环‘/root/.gnupg/pubring.gpg’已建立
gpg: 警告：没有导出任何东西
[root@node4 home]#
[root@node4 home]# rpm --import 3a79bd29.asc
错误：3a79bd29.asc: import read failed(0).
[root@node4 home]#
[root@node4 home]#
[root@node4 home]#
# 导入签名验证
[root@node4 home]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
[root@node4 home]#
[root@node4 home]#
[root@node4 home]#
# 重新--升级mysql client
[root@node4 home]# yum update mysql
已加载插件：fastestmirror, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

依赖关系解决

总计：28 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
警告：RPM 数据库已被非 yum 程序修改。
正在更新 : mysql-community-client-5.7.39-1.el7.x86_64 1/2
清理 : mysql-community-client-5.7.35-1.el7.x86_64 2/2
验证中 : mysql-community-client-5.7.39-1.el7.x86_64 1/2
验证中 : mysql-community-client-5.7.35-1.el7.x86_64 2/2

更新完毕:
mysql-community-client.x86_64 0:5.7.39-1.el7

完毕！
[root@node4 home]#
[root@node4 home]#
# 重新-- 升级mysql-server
[root@node4 home]# yum update mysql-server
已加载插件：fastestmirror, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

依赖关系解决

总计：178 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在更新 : mysql-community-common-5.7.39-1.el7.x86_64 1/4
正在更新 : mysql-community-server-5.7.39-1.el7.x86_64 2/4
清理 : mysql-community-server-5.7.35-1.el7.x86_64 3/4
清理 : mysql-community-common-5.7.35-1.el7.x86_64 4/4
验证中 : mysql-community-common-5.7.39-1.el7.x86_64 1/4
验证中 : mysql-community-server-5.7.39-1.el7.x86_64 2/4
验证中 : mysql-community-server-5.7.35-1.el7.x86_64 3/4
验证中 : mysql-community-common-5.7.35-1.el7.x86_64 4/4

更新完毕:
mysql-community-server.x86_64 0:5.7.39-1.el7

作为依赖被升级:
mysql-community-common.x86_64 0:5.7.39-1.el7

完毕！
[root@node4 home]#
[root@node4 home]#
# 再次查看 mysql 版本
[root@node4 home]# mysql -V
mysql Ver 14.14 Distrib 5.7.39, for Linux (x86_64) using EditLine wrapper
[root@node4 home]#
[root@node4 home]#
# 检测更新是否正常（很重要，报错就说明更新失败！）
[root@node4 home]# mysql_upgrade -u root -p'xx123!!!'
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
[root@node4 home]#
# 数据库还没有启动，需要启动数据
[root@node4 home]# systemctl restart mysqld
[root@node4 home]#
# 再次--检测更新是否正常
[root@node4 home]# mysql_upgrade -u root -p'xx123!!!'
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
The sys schema is already up to date (version 1.5.2).
Checking databases.
sys.sys_config OK
Upgrade process completed successfully.
Checking if update is needed.
[root@node4 home]#
[root@node4 home]#
# 再次验证更新的组件
[root@node4 home]# rpm -qa|grep ^mysql-community
mysql-community-libs-compat-5.7.35-1.el7.x86_64
mysql-community-common-5.7.39-1.el7.x86_64
mysql-community-libs-5.7.35-1.el7.x86_64
mysql-community-client-5.7.39-1.el7.x86_64
mysql-community-server-5.7.39-1.el7.x86_64
[root@node4 home]#

[root@node4 mysql]# mysql_upgrade -u root -p'xx123!!!'
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
Checking if update is needed.
This installation of MySQL is already upgraded to 5.7.39, use --force if you still need to run mysql_upgrade
[root@node4 mysql]#
[root@node4 mysql]# mysql_upgrade -u root -p'Zhxx123!!!' --force
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
The sys schema is already up to date (version 1.5.2).
Checking databases.
sys.sys_config OK
Upgrade process completed successfully.
Checking if update is needed.
[root@node4 mysql]#
[root@node4 mysql]# rpm -qa|grep ^mysql-community
mysql-community-libs-compat-5.7.35-1.el7.x86_64
mysql-community-common-5.7.39-1.el7.x86_64
mysql-community-libs-5.7.35-1.el7.x86_64
mysql-community-client-5.7.43-1.el7.x86_64
mysql-community-server-5.7.39-1.el7.x86_64
[root@node4 mysql]#
[root@node4 mysql]# yum update mysql-server
已加载插件：fastestmirror, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

Repository base is listed more than once in the configuration
Loading mirror speeds from cached hostfile
* base: mirrors.ustc.edu.cn
* extras: mirrors.aliyun.com
* updates: mirrors.ustc.edu.cn
正在解决依赖关系
--> 正在检查事务
---> 软件包 mysql-community-server.x86_64.0.5.7.39-1.el7 将被升级
---> 软件包 mysql-community-server.x86_64.0.5.7.43-1.el7 将被更新
--> 正在处理依赖关系 mysql-community-common(x86-64) = 5.7.43-1.el7，它被软件包 mysql-community-server-5.7.43-1.el7.x86_64 需要
--> 正在检查事务
---> 软件包 mysql-community-common.x86_64.0.5.7.39-1.el7 将被升级
---> 软件包 mysql-community-common.x86_64.0.5.7.43-1.el7 将被更新
--> 解决依赖关系完成

依赖关系解决

总下载量：184 M
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for mysql57-community
(1/2): mysql-community-common-5.7.43-1.el7.x86_64.rpm | 313 kB 00:00:01
(2/2): mysql-community-server-5.7.43-1.el7.x86_64.rpm | 184 MB 00:00:28
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
总计 6.4 MB/s | 184 MB 00:00:28
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在更新 : mysql-community-common-5.7.43-1.el7.x86_64 1/4
正在更新 : mysql-community-server-5.7.43-1.el7.x86_64 2/4
清理 : mysql-community-server-5.7.39-1.el7.x86_64 3/4
清理 : mysql-community-common-5.7.39-1.el7.x86_64 4/4
验证中 : mysql-community-server-5.7.43-1.el7.x86_64 1/4
验证中 : mysql-community-common-5.7.43-1.el7.x86_64 2/4
验证中 : mysql-community-common-5.7.39-1.el7.x86_64 3/4
验证中 : mysql-community-server-5.7.39-1.el7.x86_64 4/4
2023-10-18 13:27:02,912 [WARNING] yum:32548:MainThread @logutil.py:142 - logging already initialized

更新完毕:
mysql-community-server.x86_64 0:5.7.43-1.el7

作为依赖被升级:
mysql-community-common.x86_64 0:5.7.43-1.el7

完毕！
[root@node4 mysql]#
[root@node4 mysql]# rpm -qa|grep ^mysql-community
mysql-community-libs-compat-5.7.35-1.el7.x86_64
mysql-community-common-5.7.43-1.el7.x86_64
mysql-community-libs-5.7.35-1.el7.x86_64
mysql-community-client-5.7.43-1.el7.x86_64
mysql-community-server-5.7.43-1.el7.x86_64
[root@node4 mysql]# yum update mysql-libs
已加载插件：fastestmirror, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

依赖关系解决

总下载量：2.9 M
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for mysql57-community
mysql-community-libs-5.7.43-1.el7.x86_64.rpm | 2.9 MB 00:00:03
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在更新 : mysql-community-libs-5.7.43-1.el7.x86_64 1/2
清理 : mysql-community-libs-5.7.35-1.el7.x86_64 2/2
验证中 : mysql-community-libs-5.7.43-1.el7.x86_64 1/2
验证中 : mysql-community-libs-5.7.35-1.el7.x86_64 2/2
2023-10-18 13:27:43,264 [WARNING] yum:4765:MainThread @logutil.py:142 - logging already initialized

更新完毕:
mysql-community-libs.x86_64 0:5.7.43-1.el7

完毕！
[root@node4 mysql]# rpm -qa|grep ^mysql-community
mysql-community-libs-compat-5.7.35-1.el7.x86_64
mysql-community-common-5.7.43-1.el7.x86_64
mysql-community-client-5.7.43-1.el7.x86_64
mysql-community-server-5.7.43-1.el7.x86_64
mysql-community-libs-5.7.43-1.el7.x86_64
[root@node4 mysql]#
[root@node4 mysql]# yum update mysql-libs-compat
已加载插件：fastestmirror, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

依赖关系解决

总下载量：1.2 M
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for mysql57-community
mysql-community-libs-compat-5.7.43-1.el7.x86_64.rpm | 1.2 MB 00:00:02
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在更新 : mysql-community-libs-compat-5.7.43-1.el7.x86_64 1/2
清理 : mysql-community-libs-compat-5.7.35-1.el7.x86_64 2/2
验证中 : mysql-community-libs-compat-5.7.43-1.el7.x86_64 1/2
验证中 : mysql-community-libs-compat-5.7.35-1.el7.x86_64 2/2
2023-10-18 13:28:22,975 [WARNING] yum:6280:MainThread @logutil.py:142 - logging already initialized

更新完毕:
mysql-community-libs-compat.x86_64 0:5.7.43-1.el7

完毕！
[root@node4 mysql]# rpm -qa|grep ^mysql-community
mysql-community-common-5.7.43-1.el7.x86_64
mysql-community-client-5.7.43-1.el7.x86_64
mysql-community-server-5.7.43-1.el7.x86_64
mysql-community-libs-compat-5.7.43-1.el7.x86_64
mysql-community-libs-5.7.43-1.el7.x86_64
[root@node4 mysql]#