MySQL Bugs: #106200: Cannot install MySQL 5.7 packages from official yum repo

Bug #106200	Cannot install MySQL 5.7 packages from official yum repo
Submitted:	18 Jan 2022 15:49	Modified:	18 Jan 2022 17:03
Reporter:	Roman Belousov	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Package Repos	Severity:	S3 (Non-critical)
Version:		OS:	CentOS (CentOS Linux release 7.9.2009 (Core))
Assigned to:		CPU Architecture:	x86 (x86_64)
Tags:	gpg, rpm, yum

Description:
I cannot install MySQL packages from the official 5.7 repo:
mysql-community-server
mysql-community-client
mysql-community-common

yum wants to install version 5.7.37, but GPG check fails for that version. 

Workaround: I can install version 5.7.36

$ sudo yum install mysql-community-common-5.7.36

How to repeat:
1. Login to CentOS 7 machine
2. Execute the command:
$ sudo yum install https://repo.mysql.com/mysql57-community-release-el7.rpm
3. Execute the command:
$ sudo yum install mysql-community-common

See the output:

Public key for mysql-community-common-5.7.37-1.el7.x86_64.rpm is not installed
mysql-community-common-5.7.37-1.el7.x86_64.rpm                                                                                   | 311 kB  00:00:00     
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-common-5.7.37-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Suggested fix:
Fix repo metadata or package signing

Hello Roman Belousov,

Thank you for the report and feedback.
IMHO this is duplicate of Bug #106188, please see Bug #106188.

I suggest you to follow the instructions from 
Yum Repository - https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/
Also, Signature Checking Using GnuPG. https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature.html

Related - Bug #105632

regards,
Umesh

Thanks, Umesh!
I think that mysql*-community-release repository packages should be updated with proper GPG keys