Linux|centos7 安装 mysql5.7走过的坑

今天使用centos7进行mysql5.7的安装,出现挫折,记录如下: 下载安装mysql 下载rpm安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

--2022-01-22 03:01:53--http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11 Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:80... connected. HTTP request sent, awaiting response... 301 Moved Permanently Location: https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm [following] --2022-01-22 03:01:54--https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... connected. HTTP request sent, awaiting response... 302 Found Location: https://repo.mysql.com//mysql57-community-release-el7-8.noarch.rpm [following] --2022-01-22 03:01:55--https://repo.mysql.com//mysql57-community-release-el7-8.noarch.rpm Resolving repo.mysql.com (repo.mysql.com)... 23.36.253.13 Connecting to repo.mysql.com (repo.mysql.com)|23.36.253.13|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 9116 (8.9K) [application/x-redhat-package-manager] Saving to: ‘mysql57-community-release-el7-8.noarch.rpm’100%[=========================================================================================================================================================================>] 9,116--.-K/sin 0s2022-01-22 03:01:55 (249 MB/s) - ‘mysql57-community-release-el7-8.noarch.rpm’ saved [9116/9116]

安装
yum localinstall mysql57-community-release-el7-8.noarch.rpm

(py3) [root@localhost opt]# yum localinstall mysql57-community-release-el7-8.noarch.rpm Loaded plugins: fastestmirror, langpacks Examining mysql57-community-release-el7-8.noarch.rpm: mysql57-community-release-el7-8.noarch Marking mysql57-community-release-el7-8.noarch.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package mysql57-community-release.noarch 0:el7-8 will be installed --> Finished Dependency ResolutionDependencies Resolved=================================================================================================================================================================================================================== PackageArchVersionRepositorySize =================================================================================================================================================================================================================== Installing: mysql57-community-releasenoarchel7-8/mysql57-community-release-el7-8.noarch8.2 kTransaction Summary =================================================================================================================================================================================================================== Install1 PackageTotal size: 8.2 k Installed size: 8.2 k Is this ok [y/d/N]: y Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : mysql57-community-release-el7-8.noarch1/1 Verifying: mysql57-community-release-el7-8.noarch1/1 Installed: mysql57-community-release.noarch 0:el7-8Complete!

查看安装情况
(py3) [root@localhost opt]# yum repolist enabled | grep "mysql.*-community.*" mysql-connectors-community/x86_64MySQL Connectors Community167 mysql-tools-community/x86_64MySQL Tools Community82 mysql57-community/x86_64MySQL 5.7 Community Server564

安装server
yum -y install mysql-community-server

(py3) [root@localhost opt]# yum -y install mysql-community-server Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile * base: mirrors.tuna.tsinghua.edu.cn * extras: mirrors.tuna.tsinghua.edu.cn * updates: mirrors.tuna.tsinghua.edu.cn Resolving Dependencies --> Running transaction check ---> Package mysql-community-server.x86_64 0:5.7.37-1.el7 will be installed --> Processing Dependency: mysql-community-common(x86-64) = 5.7.37-1.el7 for package: mysql-community-server-5.7.37-1.el7.x86_64 --> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.37-1.el7.x86_64 --> Running transaction check ---> Package mysql-community-client.x86_64 0:5.7.37-1.el7 will be installed --> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.37-1.el7.x86_64 ---> Package mysql-community-common.x86_64 0:5.7.37-1.el7 will be installed --> Running transaction check ---> Package mysql-community-libs.x86_64 0:5.7.37-1.el7 will be installed --> Finished Dependency ResolutionDependencies Resolved=================================================================================================================================================================================================================== PackageArchVersionRepositorySize =================================================================================================================================================================================================================== Installing: mysql-community-serverx86_645.7.37-1.el7mysql57-community174 M Installing for dependencies: mysql-community-clientx86_645.7.37-1.el7mysql57-community25 M mysql-community-commonx86_645.7.37-1.el7mysql57-community311 k mysql-community-libsx86_645.7.37-1.el7mysql57-community2.4 MTransaction Summary =================================================================================================================================================================================================================== Install1 Package (+3 Dependent packages)Total download size: 202 M Installed size: 878 M Downloading packages: warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY]0.0 B/s | 767 kB--:--:-- ETA Public key for mysql-community-common-5.7.37-1.el7.x86_64.rpm is not installed (1/4): mysql-community-common-5.7.37-1.el7.x86_64.rpm| 311 kB00:00:00 (2/4): mysql-community-libs-5.7.37-1.el7.x86_64.rpm| 2.4 MB00:00:04 (3/4): mysql-community-client-5.7.37-1.el7.x86_64.rpm|25 MB00:01:01 (4/4): mysql-community-server-5.7.37-1.el7.x86_64.rpm| 174 MB00:03:40 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total917 kB/s | 202 MB00:03:45 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql Importing GPG key 0x5072E1F5: Userid: "MySQL Release Engineering " Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5 Package: mysql57-community-release-el7-8.noarch (@/mysql57-community-release-el7-8.noarch) From: /etc/pki/rpm-gpg/RPM-GPG-KEY-mysqlPublic key for mysql-community-server-5.7.37-1.el7.x86_64.rpm is not installed Failing package is: mysql-community-server-5.7.37-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

这里发现这个问题:
Public key for mysql-community-server-5.7.37-1.el7.x86_64.rpm is not installed Failing package is: mysql-community-server-5.7.37-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

备注: 由于MySQL在CentOS7中收费了,所以已经不支持MySQL了,取而代之在CentOS7内部集成了mariadb,而安装MySQL的话会和MariaDB的文件冲突。
如果安装的话,需要卸载MariaDB,另外也注意安装正确的安装包,以及安装顺序,建议参考我的另外一篇文章。

【Linux|centos7 安装 mysql5.7走过的坑】

    推荐阅读