MySQL GPG Keys (UPS-423)

[NullRoute]

Symptoms

The GPG keys for the official MySQL repository have expired preventing installation or update of MySQL packages. 

The errors are similar to:

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-community-client-8.0.28-1.el8.x86_64 GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql 
Public key for mysql-community-client-plugins-8.0.28-1.el8.x86_64.rpm is not installed. Failing package is: mysql-community-client-plugins-8.0.28-1.el8.x86_64 GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql 
Public key for mysql-community-common-8.0.28-1.el8.x86_64.rpm is not installed. Failing package is: mysql-community-common-8.0.28-1.el8.x86_64 GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql 
Public key for mysql-community-devel-8.0.28-1.el8.x86_64.rpm is not installed. Failing package is: mysql-community-devel-8.0.28-1.el8.x86_64 GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql 
Public key for mysql-community-icu-data-files-8.0.28-1.el8.x86_64.rpm is not installed. Failing package is: mysql-community-icu-data-files-8.0.28-1.el8.x86_64 GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql 
Public key for mysql-community-libs-8.0.28-1.el8.x86_64.rpm is not installed. Failing package is: mysql-community-libs-8.0.28-1.el8.x86_64 GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql 
Public key for mysql-community-server-8.0.28-1.el8.x86_64.rpm is not installed. Failing package is: mysql-community-server-8.0.28-1.el8.x86_64 GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql Error: GPG check FAILED

Description

MySQL GPG keys have expired. Additional details about case can also be found on the MySQL website: https://bugs.mysql.com/bug.php?id=106188

 

We've opened an internal case for our development team to investigate this further.

For reference, the case number is UPS-423. Follow this article to receive an email notification when a solution is published in the product. 

 

Workaround

We have released an Autofixer to correct this issue on existing cPanel systems. This will run automatically during the nightly maintenance or it can be manually run with the following:

/scripts/autorepair mysql_gpg_key

 

New installations 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 -

Alternatively, MariaDB could be installed: