Symptoms
Unable to update MySQL package on Plesk server with the folllwing error:
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
ERROR: 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
Cause
MySQL bug #106188 where GPG key used by MySQL has expired.
Resolution
1. Connect to Plesk server via SSH.
2. Import the correct key:
-
RHEL-based (CentOS, AlmaLinux, etc.):
# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
-
Debian-based (Ubuntu, Debian):
# wget -q -O https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 | apt-key add -