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...
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
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.
The GPG keys for the new release has been changed. See this for further info: https://support.cpanel.net/hc/en-us/articles/4419382481815?input_string=gpg+keys+problem+with+mysql+5.7
Steps to resovled this error the updated MySQL GPG will need to be installed.
For existing systems, the MySQL repository file in /etc/yum.repos.d/ will need to have its 'gpgkey' line adjusted to:
gpgkey=https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
Once adjusted, run the update once more:
/usr/local/cpanel/scripts/upcp
For new installations you can import the key before running the installer:
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
Ubuntu:
wget -q -O https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 | apt-key add -