The GPG keys listed for the “MySQL 5.7 Community Server“ repository are alread__一蓑烟雨任平生

最新推荐文章于 2024-10-11 17:14:36 发布

原创最新推荐文章于 2024-10-11 17:14:36 发布 · 7.3k 阅读

29 ·

CC 4.0 BY-SA版权

文章标签：

#linux

日常笔记专栏收录该内容

6 篇文章

订阅专栏

在2022年和2023年间，个人搭建网站安装MySQL 5.7时遇到GPG钥匙不匹配的问题。错误提示表明已经安装的GPG钥匙与当前包不符。解决方案是通过运行`rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022`来导入正确的GPG钥匙。

项目场景：

自己搭建个人网站,安装MySql时候遇到的问题

问题描述

The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.

 Failing package is: mysql-community-server-5.7.37-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

原因分析：

版本问题今年2022 明年2023

解决方案：

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

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

一蓑烟雨任平生√

关注关注

26
点赞
踩
29

收藏

觉得还不错? 一键收藏
3
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

CDH大数据平台 The GPG keys listed for the “MySQL 5.7 Community Server“ repository are already installed b

80后大叔爱学习

11-17

603

The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.

Xshell安装sql报错：The GPG keys listed for the “MySQL 8.0 Community Server“ repository are already instal

草巾冒小子的博客

03-04

3283

文章目录Xshell安装sql报错：The GPG keys listed for the "MySQL 8.0 Community Server" repository are already installed but they are not correct for this package.报错信息、报错截图 · 示下：原因分析：解决办法： Xshell安装sql报错：The GPG keys listed for the “MySQL 8.0 Community Server” reposit

3 条评论您还未登录，请先登录后发表或查看评论

3 条评论

m0_55166986 2023.03.09
今年是2023，还是要用2022

RAMemories 2022.08.06
有个需要注意的地方，需要是root用户，或者sudo才能这样做，不然会出现三个error

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

QQ657205470的博客

01-23

2700

警告：/var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-server-5.7.44-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY从 file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 检索密钥源 “MySQL 5.7 Community Server” 的 GPG 密钥已安装，但是不适用于此软件包。

linux-Mysql安装出错-The GPG keys listed for the “MySQL 5.7 Community Server“ repository are already...

gacaguet的博客

03-14

9045

安装mysql出错The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.

Hadoop安装MySQL报错The GPG keys listed for the “MySQL 5.7 Community Server“ repository are already......

m0_73139998的博客

05-25

4638

本文讲解如何解决Hadoop安装MySQL服务时报错-The GPG keys listed for the "MySQL 5.7 Community Server" repository are already......

The GPG keys listed for the “MySQL 5.7 Community Server“ repository are already installed but...

qq_32812063的博客

06-02

1620

Failing package is: mysql-community-common-5.7.38-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql --nogpgcheck

The GPG keys listed for the “MySQL 5.7 Community Server“ repository are already installed but they a

geniusbluesky的博客

05-11

2735

The GPG keys listed for the “MySQL 5.7 Community Server” repository are already installed but they are not correct for this package. 错误信息 Downloading packages: warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-client-5.7.38-1.el7.

阿里云CentOS7安装MySQL5.7报错GPG校验不正确

ArYe

02-16

1731

MySQL报错 Failing package is: mysql-community-server-5.7.37-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql Failed to start mysqld.service: Unit not found.

centos7安装mysql8.0

to3zto3z的博客

08-30

528

centos7安装mysql8.0

Centos 7 安装MySQL报错：The GPG keys listed for the “MySQL 5.7 Community Server“ repository are

随风

03-24

9568

Downloading packages: warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-server-5.7.37-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 The GP.

The GPG keys listed for the “MySQL 5.7 Community Server“ repository are already installed but they

巅峰产生虚伪的拥护，黄昏见证虞城的信徒。

05-17

714

自己在搭建zabbix，安装mysql时遇到的问题。

数据中台部署-安装mysql报错 The GPG keys listed for the “MySQL5.7 Community Server“ repository are already inst

ye_chen_的博客

10-11

684

找到[mysql5.7-community] 修改：gpgcheck参数为0，即不校验gpg。解决办法：禁用GPG验证检查。

The GPG keys listed for the “MySQL 8.0 Community Server“ repository are already installed but they a

Knight

10-01

3397

这个是由于GPG密钥验证问题引起的。

The GPG keys listed for the “MySQL 8.0 Community Server“..but they are not correct for this package

卢说

05-10

3176

问题描述 yum install mysql 报错 The GPG keys listed for the "MySQL 8.0 Community Server" repository are already installed but they are not correct for this package. Check that the correct key URLs are configured for this repository. Failing package is: mysql

[解决mysql密钥过期问题]Centos7安装MySQL时报错：The GPG keys listed for the “MySQL 5.7 Community Server“

weixin_39266845的博客

10-14

1005

centos7解决mysql密钥过期问题

mysql5.7在centos环境下的常见故障

shgh_2004的专栏

08-18

961

由于部分数据文件损害，导致mysql在启动过程之中，会检查一些部分内容失败，导致mysql服务启动失败。1. 设置mysql启动时候的恢复引导级别。跳过部分内容的加载和校验，启动mysql服务；3. 重置mysql服务器（重新实例化）4. 重新设置mysql引导设置级别。5. 用第二步备份的数据，来恢复；2. copy出数据库中的数据；

Centos7安装mysql遇到的问题

了解—学习—进步—满足

03-07

1357

Centos7安装mysql遇到的问题：The GPG keys listed for the “MySQL 5.7 Community Server” repository are already installed but they are not correct for this package. Check that the correct key URLs are configured for this repository. Failing package is: mysql-communit

CentOS7.9 安装 MySQL5.7

CodingMan

05-02

1878

简介在 CentOS 7 上面安装 MySQL5.7 经历了一点小挫折，特此记录，给有需要的朋友做个参考。我的云主机 CentOS 版本 > lsb_release -a LSB Version: :core-4.1-amd64:core-4.1-noarch Distributor ID: CentOS Description: CentOS Linux release 7.9.2009 (Core) Release: 7.9.2009 Codename: Core 安装 MySQL 因为现

【环境踩坑系列】CentOS7 安装 MySQl 5.7.25

BugMan的博客

09-20

1827

centOS安装mysql踩坑教程，复制粘贴即可，保证快速安装

The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package. Check that the correct key URLs are configured for this repository. Failing package is: mysql-community-libs-5.7.44-1.el7.x86_64 GPG Keys are configured as: https://repo.mysql.com/RPM-GPG-KEY-mysql

最新发布

04-29

<think>好的，用户遇到了MySQL 5.7社区服务器仓库中GPG密钥不匹配的问题，具体是安装mysql-community-libs-5.7.44-1.el7.x86_64时出现的错误。我需要帮他解决这个问题。首先，GPG密钥不匹配通常发生在RPM包验证时，系统无法找到正确的公钥来验证签名。这可能是因为密钥未正确导入，或者仓库配置中的密钥过期或错误。根据引用[2]，当遇到签名验证失败时，解决方法是导入正确的GPG密钥。例如，CentOS系统中通过rpm --import命令导入密钥。因此，用户可能需要手动下载并导入MySQL的GPG密钥。接下来，我需要确认MySQL官方提供的GPG密钥位置。通常，MySQL的GPG密钥可以从其官方网站或仓库配置中获取。用户可能使用的仓库配置文件中已经指定了密钥的URL，但可能需要手动下载并导入。另外，用户提到的错误信息中提到了RPM-GPG-KEY-mysql，这可能是指MySQL仓库中的密钥文件。需要检查是否该密钥已正确安装到系统中。如果密钥不存在或版本过旧，就会导致验证失败。可能的解决步骤包括： 1. 清除旧的GPG密钥缓存。 2. 下载最新的MySQL GPG密钥。 3. 导入密钥到RPM数据库中。 4. 重新安装MySQL包，验证是否解决。还需要考虑仓库配置是否正确，可能用户使用的仓库地址有误，或者密钥文件路径在配置中没有正确指向。例如，在.repo文件中是否指定了正确的gpgkey=URL。另外，用户可能之前尝试过自动导入密钥，但失败了，所以需要手动操作。或者系统的时间设置不正确，导致证书验证失败，但这种情况可能性较低，用户的问题更可能直接与密钥相关。最后，确保所有步骤执行后，再次运行安装命令，应该能够通过GPG验证。如果问题依旧，可能需要检查密钥是否对应正确的MySQL版本，或者是否有其他仓库冲突。</think>### 解决MySQL 5.7 GPG密钥不匹配问题的方法 #### 问题原因安装MySQL 5.7时出现`GPG key mismatch`错误，通常是由于RPM包验证时未找到匹配的公钥导致。MySQL社区版仓库的GPG密钥可能未正确导入或已过期[^2]。 --- #### 解决方法 ##### 1. **清除旧密钥** 首先检查系统中是否残留旧版MySQL密钥： ```bash rpm -qa | grep 'gpg-pubkey' | grep -i mysql ``` 若存在旧密钥（例如`gpg-pubkey-3a79bd29`），使用以下命令删除： ```bash rpm -e gpg-pubkey-3a79bd29 ``` ##### 2. **手动下载并导入GPG密钥** 从MySQL官方获取最新GPG密钥并导入： ```bash # 下载密钥 curl -sSL https://repo.mysql.com/RPM-GPG-KEY-mysql -o /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-5.7 # 导入密钥 rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-5.7 ``` ##### 3. **验证密钥状态** 检查密钥是否成功导入： ```bash rpm -qi gpg-pubkey-$(rpm -qa | grep 'gpg-pubkey' | grep mysql | cut -d- -f4) ``` ##### 4. **重新安装MySQL包** 再次尝试安装操作： ```bash yum install mysql-community-server-5.7.44-1.el7.x86_64 ``` --- #### 注意事项 - **仓库配置检查**：确保`/etc/yum.repos.d/mysql-community.repo`中`gpgkey`指向正确的密钥URL[^1]。 - **时间同步**：若系统时间偏差过大，可能导致验证失败，使用`ntpdate`同步时间： ```bash ntpdate pool.ntp.org ``` ---