MySQL on Linux - Incorrect GPG Keys Installed
Problem
You get an error when trying to run sudo yum update
for MySQL packages. It used to work OK but now you get an error message similar to this:
|
|
Solution
One solution (not the only solution) is to use the following command:
|
|
Discussion
The --import
option to the rpm
command imports the public key from the given URL into the RPM key database on the server. This is needed for MySQL to verify the downloaded version of the MySQL installation software.
The above URL for the key RPM-GPG-KEY-mysql-2022
applies to MySQL 8.0.28 packages and higher. Prior versions of MySQL (e.g. the version you may have originally installed) use a different key.
To be sure you have the right key, you can visit this official MySQL documentation page, which shows the contents of the key.
You can also read about the RPM signature checking process here, which refers to the URL shown above.
Using the above rpm --import
command causes the key to be stored in the RPM database in /var/lib/rpm/
.
To see what is stored there, you can use the command:
|
|
To see details for the MySQL key you can use the following command:
|
|
where 3a79bd29
is the key ID (as shown here).
The output:
|
|
Another approach is to go to the MIT PGP Public Key Server, and enter the search string:
|
|
This will return the following (and maybe other newer/older hits):
|
|
From there you can navigate to the specific key ID (3A79BD29
) - and then to the text of the public key on the MIT public key server.
Author northCoder
LastMod 13-Nov-2022