centos安装mysql遇到的问题

centos安装mysql遇到的问题

一 提示mysql-community-libs-compat的GPG不对

错误信息：

warning: /var/cache/yum/x86_64/7/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

参考 https://forums.cpanel.net/threads/ups-421-mysql-5-7-36-5-7-37-upgrade-failed-due-to-gpg-keys-causing-upcp-rpmup-failure-warning-email.697217/ 得到答案：

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

--------------

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 -

大致意思就是MySQL的GPG升级了，需要更新，如果是新安装的MySQL，执行以下脚本即可：

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

更新的话，就需要更改/etc/yum.repos.d/文件