GPG keys issue while installing mysql-community-server-CodePudding

While Installing mysql-community-server getting bellow error:

Command:

 sudo yum install mysql-community-server

Error:

warning: /var/cache/yum/x86_64/2/mysql57-community/packages/mysql-community-libs-compat-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 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-compat-5.7.37-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Can anyone help on this...

CodePudding user response：

I had the same problem with two DNS-ONLY servers.

I edited the /etd/yum.repos.d/Mysql57.repo file and changed all the "gpgcheck=1" lines to "gpgcheck=0"

Then I executed yum update

Then I edited the /etd/yum.repos.d/Mysql57.repo file and changed all the "gpgcheck=0" lines back to "gpgcheck=1"

Finally, I updated the cPanel software.

CodePudding user response：

From: https://dev.mysql.com/doc/refman/8.0/en/checking-rpm-signature.html

There is no separate signature. RPM packages have a built-in GPG signature and MD5 checksum.

rpm also supports loading the key directly from a URL:

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