在CentOS 8上安装MySQL 5.7

Question

我试图在CentOS 8上安装MySQL 5.7社区服务器，但是我想不出一种方法来配置任何可以工作的回购。

$ yum repolist all | grep mysql
CentOS-8 - AppStream                            2.2 kB/s | 4.3 kB     00:02    
CentOS-8 - Base                                 2.3 kB/s | 3.9 kB     00:01    
CentOS-8 - Extras                               2.1 kB/s | 1.5 kB     00:00    
CentOS-8 - PowerTools                           7.8 kB/s | 4.3 kB     00:00    

使用yum / dnf进行安装都会给我同样的结果：

$ sudo dnf install @mysql
Last metadata expiration check: 0:07:30 ago on Tue 03 Dec 2019 02:16:26 AM UTC.
Dependencies resolved.
==============================================================================================================
 Package                              Arch      Version                                  Repository      Size
==============================================================================================================
Installing group/module packages:
 mysql-server                         x86_64    8.0.17-3.module_el8.0.0+181+899d6349     AppStream       22 M
Installing dependencies:
 mariadb-connector-c-config           noarch    3.0.7-1.el8                              AppStream       13 k
 mecab                                x86_64    0.996-1.module_el8.0.0+41+ca30bab6.9     AppStream      397 k
 mysql                                x86_64    8.0.17-3.module_el8.0.0+181+899d6349     AppStream       11 M
 mysql-common                         x86_64    8.0.17-3.module_el8.0.0+181+899d6349     AppStream      143 k
 mysql-errmsg                         x86_64    8.0.17-3.module_el8.0.0+181+899d6349     AppStream      557 k
 protobuf-lite                        x86_64    3.5.0-7.el8                              AppStream      150 k
 libaio                               x86_64    0.3.110-12.el8                           BaseOS          32 k
 numactl-libs                         x86_64    2.0.12-2.el8                             BaseOS          36 k
 policycoreutils-python-utils         noarch    2.8-16.1.el8                             BaseOS         228 k

在CentOS 8上可以安装MySQL5.7吗？

Answer 1

我按照这里找到的说明，在CentOS 8上安装了CentOS 5.7

在MySQL 8/MySQL 8Linux上安装CentOS 5.7

[root@mysql01 ~]cat /etc/*release* | grep release
CentOS Linux release 8.0.1905 (Core)

[root@mysql01 ~]# rpm -qi mysql-community-server
Name        : mysql-community-server
Version     : 5.7.29
Release     : 1.el7
Architecture: x86_64

Answer 2

正如托尼上面提到的，这里是如何在centos 8上安装MySQL5.7的一步一步的指南。

万一有一天博客会掉下来，下面是所有相关步骤的摘录

step1:删除mysql默认流

sudo dnf remove @mysql
sudo dnf module reset mysql && sudo dnf module disable mysql

step2:添加MySQL5.7回购

文件：

/etc/yum.repos.d/mysql-community.repo

内容：

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=0

[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/7/$basearch/
enabled=1
gpgcheck=0

[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/7/$basearch/
enabled=1
gpgcheck=0

step3:照常安装

sudo dnf --enablerepo=mysql57-community install mysql-community-server

其余步骤(密码和安全安装与5.7安装相同)

#start
sudo systemctl enable --now mysqld.service
#read temp password
grep 'A temporary password' /var/log/mysqld.log |tail -1
#secure it
sudo mysql_secure_installation