Centos6..5使用yum安装mysql时提示NoKey

在CentosLinux下用yum安装mysql时有时候会出现下面错误导致安装失败

warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY


Public key for mysql-community-client-5.6.40-2.el6.x86_64.rpm is not installed

这是由于yum安装了旧版本的GPG keys造成的，解决办法是可以运行下面命令：

$ sudo rpm --import /etc/pki/rpm-gpg/RPM*  

报错

Location: https://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm [following]
--2018-04-24 03:52:59--  https://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Connecting to dev.mysql.com|137.254.60.11|:443... connected.
ERROR: certificate common name “www.mysql.com” doesn’t match requested host name “dev.mysql.com”.
To connect to dev.mysql.com insecurely, use ‘--no-check-certificate’

当wget 命令访问https的时候需要添加–no-check-certificate参数 –不检查证书

[root@localhost ~]# wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm --no-check-certificate

报错

[root@localhost ~]# yum localinstall mysql-community-release-el6-5.noarch.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Local Package Process
Examining mysql-community-release-el6-5.noarch.rpm: mysql-community-release-el6-5.noarch
Marking mysql-community-release-el6-5.noarch.rpm to be installed
Loading mirror 反应 speeds from cached hostfile 主文件
 * base: mirrors.cn99.com
 * extras: mirror.bit.edu.cn
 * updates: mirror.bit.edu.cn
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-release.noarch 0:el6-5 will be installed
--> Processing Conflict: mysql57-community-release-el6-8.noarch conflicts mysql-community-release
No package matched to upgrade: mysql-community-release
--> Finished Dependency Resolution
Error: mysql57-community-release conflicts with mysql-community-release-el6-5.noarch
 You could try using --skip-broken to work around the problem
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
perl-DBD-MySQL-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16()(64bit)
perl-DBD-MySQL-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit)

解决:

yum localinstall mysql-community-release-el6-5.noarch.rpm --skip-broken