【MySQL 08】GPG key retrieval failed: “Couldn‘t open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022“

已于 2022-07-02 11:31:33 修改
阅读量1.4k 收藏 1
点赞数
分类专栏： # MySQL 文章标签： mysql centos linux
于 2022-06-30 16:59:44 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_22938603/article/details/125544109
版权

1、现象

Centos 7.9 安装mysql 是出现异常，GPG key retrieval failed: [Errno 14] curl#37 - “Couldn’t open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022”

原因：出现上述提示原因是Mysql的GPG升级了，需要重新获取

[root@localhost /]# yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.29-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-icu-data-files = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: net-tools for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.29-1.el7 will be installed
--> Processing Dependency: mysql-community-client-plugins = 8.0.29-1.el7 for package: mysql-community-client-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.29-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.29-1.el7 will be installed
---> Package mysql-community-icu-data-files.x86_64 0:8.0.29-1.el7 will be installed
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
---> Package mysql-community-client-plugins.x86_64 0:8.0.29-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:8.0.29-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:8.0.29-1.el7 will be obsoleting
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================================================================================================== Package                                                         Arch                                    Version                                                     Repository                                          Size
==============================================================================================================================================================================================================================Installing:
 mysql-community-libs                                            x86_64                                  8.0.29-1.el7                                                mysql80-community                                  1.5 M
     replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
 mysql-community-libs-compat                                     x86_64                                  8.0.29-1.el7                                                mysql80-community                                  667 k
     replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
 mysql-community-server                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                   53 M
Installing for dependencies:
 mysql-community-client                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                   14 M
 mysql-community-client-plugins                                  x86_64                                  8.0.29-1.el7                                                mysql80-community                                  2.5 M
 mysql-community-common                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                  633 k
 mysql-community-icu-data-files                                  x86_64                                  8.0.29-1.el7                                                mysql80-community                                  2.1 M
 net-tools                                                       x86_64                                  2.0-0.25.20131004git.el7                                    base                                               306 k

Transaction Summary
==============================================================================================================================================================================================================================Install  3 Packages (+5 Dependent packages)

Total size: 75 M
Total download size: 70 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY                  ] 2.2 MB/s |  11 MB  00:00:27 ETA 
Public key for mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm is not installed
(1/4): mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm                                                                                                                                          | 2.1 MB  00:00:03     
(2/4): mysql-community-client-8.0.29-1.el7.x86_64.rpm                                                                                                                                                  |  14 MB  00:00:03     
(3/4): net-tools-2.0-0.25.20131004git.el7.x86_64.rpm                                                                                                                                                   | 306 kB  00:00:03     
(4/4): mysql-community-server-8.0.29-1.el7.x86_64.rpm                                                                                                                                                  |  53 MB  00:00:08     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Total                                                                                                                                                                                         6.0 MB/s |  70 MB  00:00:11     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022


GPG key retrieval failed: [Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022"

2、解决方案

执行命令：

 rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

之后再次下载mysql：

[root@localhost /]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
[root@localhost /]# yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.29-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-icu-data-files = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: net-tools for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.29-1.el7 will be installed
--> Processing Dependency: mysql-community-client-plugins = 8.0.29-1.el7 for package: mysql-community-client-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.29-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.29-1.el7 will be installed
---> Package mysql-community-icu-data-files.x86_64 0:8.0.29-1.el7 will be installed
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
---> Package mysql-community-client-plugins.x86_64 0:8.0.29-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:8.0.29-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:8.0.29-1.el7 will be obsoleting
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================================================================================================== Package                                                         Arch                                    Version                                                     Repository                                          Size
==============================================================================================================================================================================================================================Installing:
mysql-community-libs                                            x86_64                                  8.0.29-1.el7                                                mysql80-community                                  1.5 M
    replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
mysql-community-libs-compat                                     x86_64                                  8.0.29-1.el7                                                mysql80-community                                  667 k
    replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
mysql-community-server                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                   53 M
Installing for dependencies:
mysql-community-client                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                   14 M
mysql-community-client-plugins                                  x86_64                                  8.0.29-1.el7                                                mysql80-community                                  2.5 M
mysql-community-common                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                  633 k
mysql-community-icu-data-files                                  x86_64                                  8.0.29-1.el7                                                mysql80-community                                  2.1 M
net-tools                                                       x86_64                                  2.0-0.25.20131004git.el7                                    base                                               306 k

Transaction Summary
==============================================================================================================================================================================================================================Install  3 Packages (+5 Dependent packages)

Total size: 75 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
 Installing : mysql-community-common-8.0.29-1.el7.x86_64                                                                                                                                                                 1/9 
 Installing : mysql-community-client-plugins-8.0.29-1.el7.x86_64                                                                                                                                                         2/9 
 Installing : mysql-community-libs-8.0.29-1.el7.x86_64                                                                                                                                                                   3/9 
 Installing : mysql-community-client-8.0.29-1.el7.x86_64                                                                                                                                                                 4/9 
 Installing : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                                                                                                  5/9 
 Installing : mysql-community-icu-data-files-8.0.29-1.el7.x86_64                                                                                                                                                         6/9 
 Installing : mysql-community-server-8.0.29-1.el7.x86_64                                                                                                                                                                 7/9 
 Installing : mysql-community-libs-compat-8.0.29-1.el7.x86_64                                                                                                                                                            8/9 
 Erasing    : 1:mariadb-libs-5.5.68-1.el7.x86_64                                                                                                                                                                         9/9 
 Verifying  : mysql-community-icu-data-files-8.0.29-1.el7.x86_64                                                                                                                                                         1/9 
 Verifying  : mysql-community-libs-compat-8.0.29-1.el7.x86_64                                                                                                                                                            2/9 
 Verifying  : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                                                                                                  3/9 
 Verifying  : mysql-community-client-8.0.29-1.el7.x86_64                                                                                                                                                                 4/9 
 Verifying  : mysql-community-client-plugins-8.0.29-1.el7.x86_64                                                                                                                                                         5/9 
 Verifying  : mysql-community-server-8.0.29-1.el7.x86_64                                                                                                                                                                 6/9 
 Verifying  : mysql-community-common-8.0.29-1.el7.x86_64                                                                                                                                                                 7/9 
 Verifying  : mysql-community-libs-8.0.29-1.el7.x86_64                                                                                                                                                                   8/9 
 Verifying  : 1:mariadb-libs-5.5.68-1.el7.x86_64                                                                                                                                                                         9/9 

Installed:
 mysql-community-libs.x86_64 0:8.0.29-1.el7                            mysql-community-libs-compat.x86_64 0:8.0.29-1.el7                            mysql-community-server.x86_64 0:8.0.29-1.el7                           

Dependency Installed:
 mysql-community-client.x86_64 0:8.0.29-1.el7       mysql-community-client-plugins.x86_64 0:8.0.29-1.el7       mysql-community-common.x86_64 0:8.0.29-1.el7       mysql-community-icu-data-files.x86_64 0:8.0.29-1.el7      
 net-tools.x86_64 0:2.0-0.25.20131004git.el7       

Replaced:
 mariadb-libs.x86_64 1:5.5.68-1.el7                                                                                                                                                                                          

Complete!
[root@localhost /]#
Rusty well began
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
记录无法安装mysql-Invalid GPG Key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql的解决办法
09-09
在aliyun上安装MySQL时由于上次错误卸载mysql 导致校验文件出问题。下面小编给大家分享记录无法安装mysql-Invalid GPG Key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql的解决方法，需要的朋友参考下吧
RPM-GPG-KEY-mysql
08-27
用于mysql5.7.35安装验证
build-secure-gpg-key:构建安全的GPG密钥
04-11
构建安全的GPG密钥 开始构建新的密钥对... 为此，我建议您在上引导并保持脱机状态，Tails Linux包含许多不错的东西，例如 ，持久性加密卷以及许多其他东西。 生成新的密钥（仅具有C | capability标志） $ gpg --expert --full-generate-key 您可以选择创建一个RSA，ECC密钥，过程是相同的，为此Wiki，我创建一个ECC密钥： gpg (GnuPG) 2.2.19; Copyright (C) 2019 Free Software Foundation, Inc. This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Please select
RPM-GPG-KEY-cloudera
07-21
CDH 5.X RPM-GPG-KEY-cloudera
bouncy-gpg:再次将Bouncy Castle与OpenPGP结合使用会很有趣！
05-04
寻找贡献者：独自工作很无聊-如果您有兴趣为开源项目做贡献，请提出一个问题以讨论您的想法或创建PR 使命宣言 在使用 伟大的再次有趣！ 该项目为您提供以下超级功能 只需几行代码即可加密，解密，签名和验证GPG / PGP文件 通过使用读取加密文件来保护所有 您甚至可以-永远不要让纯文本打入您的服务器磁盘！ 例子 Bouncy GPG内置了几个。 密钥管理 Bouncy GPG支持读取gpg 密钥环和解析通过gpg --export和gpg --export-secret-key 导出gpg --export-secret-key 。 单元测试中有一些创建/读取密钥环的示例。 管理密钥环的最简单方法是使用预定义的KeyringConfigs 。 加密并签名文件，然后解密并验证签名 下面的代码片段加密秘密消息[email protected] （并且还自我加密到sender@ex
GPG key retrieval failed
weixin_34128501的博客
05-24 450
  Total size: 340 k Installed size: 1.2 M Is this ok [y/N]: y Downloading Packages: warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID 79ea5ed4: NOKEY Retrieving key from file:///etc/pk...
mysql gpg key retrieval failed_GPG key retrieval failed
weixin_35995835的博客
01-20 224
Total size: 340 kInstalled size: 1.2 MIs this ok [y/N]: yDownloading Packages:warning: rpmts_HdrFromFdno: Header V4 DSA/SHA1 Signature, key ID 79ea5ed4: NOKEYRetrieving key from file:///etc/pki/rpm-gp...
GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6
热门推荐
superbfly的专栏
05-18 2万+
第一种是把这个key从这个源站copy过来，放到/etc/pki/rpm-gpg目录下 第二种是修改repo文件 vim /etc/yum.repos.d/epel.repo [epel] name=Extra Packages for Enterprise Linux 6 – $basearch #baseurl=http://download.fedoraproject.or
解决GPG key retrieval failed: [Errno 14] curl#37 问题
qq_35009393的博客
05-15 1万+
在centos7中安装程序时经常会遇到这个问题：（此处是安装MySQL） GPG key retrieval failed: [Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022" 原因是yum源开启了GPG校验，开启校验后需要在/etc/pki/rpm-gpg 目录下有对应的安装文件公钥文件，才能完成校验。 在个人环境下可以直接关闭yum源中的GPG校验规避这个问题。如关闭MySQL yum源
MySQL安装报错：Couldn‘t open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
JadePlus的技术博客
06-14 2220
在CentOS 7上安装MySQL时遇到错误：Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022 GPG key retrieval failed: [Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022"需要先运行下面的命令 rpm --import https://repo.mysql.com/RPM-GPG-KEY-
GPG key retrieval failed: [Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL
liushaochan123的专栏
02-20 3727
Facebook是外国人人网 Twitter是外国的微博 Youtobe 是外国的优酷
fedora20安装后解更新或者安装软件的时候出现的 获取 GPG 密钥失败 Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-x86_64
xdzfli的专栏
03-01 8393
对于这个问题在网上找了一会后来根据多个帖子找到了解决方法，首先是根据这个http://zxn990.blog.51cto.com/4253193/1167894 每个fusion源发布的稳定 RPM 软件包都配有一个GPG签名。默认情况下，yum 和图形更新工具验证这些签名并拒绝安装任何没有签名或者签名损坏的软件包。您总是应该在安装软件包之前验证其签名。这些签名可确保您要安装的软件包出自
记录linux安装mysql出现key错误的问题
m0_50444361的博客
03-21 3425
记录linux安装mysql出现key错误的问题 报错信息: warning: /var/cache/yum/x86_64/2/mysql80-community/packages/mysql-community-client-8.0.28-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
mysql安装错误
weixin_47857252的博客
04-07 916
mysql安装错误 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 解决方案 步骤一 vi /etc/yum.repos.d/mysql-community.repo 步骤二 **你是什么版本就修改啥版本的 gpgcheck=0** [mysql80-community] name=MySQL 8.0 Community Server baseurl=http://repo.mysql.com/yum/mysql-
mysql gpg key retrieval failed_个人日常linux相关工作问题汇总
weixin_27028523的博客
01-27 269
--此篇博文记录自己学习Linux及Linux工作中遇到的各种故障及问题的汇总一、CentOS6.5中安装Mysql后在建立mysql库时并初始化时出现错误提示：Installing MySQL system tables..../bin/mysqld: error while loading shared libraries: libstdc++.so.5: cannot open shared...
GPG key retrieval failed: [Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-EPE
yjk13703623757的博客
05-26 1万+
问题 GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-7 解决方法 把这个key从源站copy过来，放到/etc/pki/rpm-gpg目录下 修改repo文件 # vim /etc/yum.repos.d/epel.rep...
yum install error – GPG key retrieval failed
preamble_1的博客
04-28 953
yum install error – GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle Posted on November 17, 2014 by Amol — No Comments ↓ Action: Installi
fedora18安装软件时出现GPG key retrieval failed: [Errno 14]的解决方案
Xinspace
04-02 735
前两天我在fedora18上看视频的时候就遇到了这个问题，在装视频播放器解码插件的时候就出现过这个问题： GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-rpmfusion-free-fedora-18-i386 不过上次的解决方案是下载KEY文件，
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
最新发布
09-27
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 是指向MySQL的GPG密钥文件的路径。GPG密钥用于验证软件包的完整性和安全性。在Mysql报错中提到的错误原因是GPG密钥未正确配置。解决方法是执行以下命令：rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022，该命令将导入正确的GPG密钥。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值