无法在MySQL上安装CENTOS7

Question

我在CentOS 7(CentOS Linux发布版7.9.2009 (Core))上，从头开始在一个新服务器上安装MySQL (7或8)。

我遵循了我的步骤-which --我在过去已经成功地完成了很多次，还有许多其他的站点，比如：

• https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/
• https://www.mysql.r2schools.com/how-to-install-mysql-8-on-centos/
• https://tecadmin.net/install-mysql-8-on-centos/#:~:text=MySQL%208%20is%20the%20latest,LInux%20using%20the%20package%20manager.

和其他许多人

所有的方法都同意这些步骤：

1. 下载并添加以下MySQL Yum存储库

数独wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

注意:我尝试了不同的版本7-5和8。

1. 安装下载的软件包

sudo yum安装mysql80 80-community EL7-3.noarch.rpm -y

1. 安装MySQL：

sudo yum安装mysql-server -y

在步骤3中，安装失败

mysql -V
-bash: mysql: command not found

我得到了所有这些错误

Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libtirpc.so.3()(64bit)
Error: Package: mysql-community-libs-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.20)(64bit)
Error: Package: mysql-community-client-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libc.so.6(GLIBC_2.28)(64bit)
Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.20)(64bit)
Error: Package: mysql-community-libs-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libc.so.6(GLIBC_2.28)(64bit)
Error: Package: mysql-community-client-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.20)(64bit)
Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libtirpc.so.3(TIRPC_0.3.3)(64bit)
Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.22)(64bit)
Error: Package: mysql-community-client-plugins-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.20)(64bit)
Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.21)(64bit)
Error: Package: mysql-community-client-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.21)(64bit)
Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.9)(64bit)
Error: Package: mysql-community-client-plugins-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.21)(64bit)
Error: Package: mysql-community-libs-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.9)(64bit)
Error: Package: mysql-community-client-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.9)(64bit)
Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.8)(64bit)
Error: Package: mysql-community-client-plugins-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.8)(64bit)
Error: Package: mysql-community-client-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libncurses.so.6()(64bit)
Error: Package: mysql-community-client-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libtinfo.so.6()(64bit)
Error: Package: mysql-community-libs-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.21)(64bit)
Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.11)(64bit)
Error: Package: mysql-community-client-plugins-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libc.so.6(GLIBC_2.25)(64bit)
Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libc.so.6(GLIBC_2.28)(64bit)
Error: Package: mysql-community-server-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libtirpc.so.3(TIRPC_0.3.0)(64bit)
Error: Package: mysql-community-client-plugins-8.0.28-1.el8.x86_64 (mysql80-community)
           Requires: libstdc++.so.6(CXXABI_1.3.9)(64bit)

我看过这篇类似的文章，但也没有运气。

• https://unix.stackexchange.com/questions/205500/i-can-not-install-mysql-using-yum-on-centos7

我唯一能够成功安装的版本是一个非常老的mysql版本: 5.6

对于我缺少的东西有什么想法或建议，或者如何解决？

Answer 1

我想我明白了。这是我为解决这个问题所做的。

###步骤1：-删除以前安装的包并清除缓存###

# look for the mysql installed packages
sudo yum list installed | grep mysql

sudo yum remove mysql80-community-release.noarch

sudo yum clean all --verbose

#manually remove remaining mysql cache folders
#from: https://serverfault.com/questions/1028593/mysql-packages-skipped-dependency-problems
sudo rm -R /var/cache/yum/x86_64/7/mysql*

sudo yum update

来自：https://tecadmin.net/install-mysql-8-on-centos/

###步骤2：-建立Yum ###

rpm -Uvh https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

###步骤3：-禁用mysql回购文件中的所有存储库。###

sed -i 's/enabled=1/enabled=0/' /etc/yum.repos.d/mysql-community.repo

###步骤4-安装MySQL社区服务器###

yum --enablerepo=mysql80-community install mysql-community-server 

得到以下错误：

The GPG keys listed for the "MySQL 8.0 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-client-8.0.28-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

来自https://forums.cpanel.net/threads/mysql-upgrade-process-failed-the-gpg-keys-listed-for-the-mysql-8-0-community-server-repository-are-already-installed-but-they-are-not-correct-for.697213/

###步骤#5 -import新的GPG键###

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

###步骤6-重新运行步骤3安装MySQL社区服务器###

yum --enablerepo=mysql80-community install mysql-community-server

获取与每种不同语言相关的多条警告消息；例如，与“英语”相关的警告消息

warning: file /usr/share/mysql/english/errmsg.sys: remove failed: No such file or directory
warning: file /usr/share/mysql/english: remove failed: No such file or directory

然而，最后的信息是成功的：

Installed:
  mysql-community-libs.x86_64 0:8.0.28-1.el7                                                  
  mysql-community-libs-compat.x86_64 0:8.0.28-1.el7                                           
  mysql-community-server.x86_64 0:8.0.28-1.el7                                                

Dependency Installed:
  mysql-community-client.x86_64 0:8.0.28-1.el7                                                
  mysql-community-client-plugins.x86_64 0:8.0.28-1.el7                                        
  mysql-community-common.x86_64 0:8.0.28-1.el7                                                
  mysql-community-icu-data-files.x86_64 0:8.0.28-1.el7                                        

Replaced:
  mariadb-libs.x86_64 1:5.5.68-1.el7                                                          

Complete!

###步骤7:测试###

mysql -V

# output #
mysql Ver 8.0.28 for Linux on x86_64 (MySQL Community Server - GPL)

###步骤8:在运行yum更新###时反复检查是否有错误

sudo yum update

通过手动启动、检查状态、来确认

sudo systemctl start mysqld
sudo systemctl status mysqld

• ​

Answer 2

在我的例子中，我只是导入了GPG-KEY：

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

在此之后，下一个命令将无错误地运行：

sudo yum install mysql-server -y

Answer 3

rpm -qa | grep mariadb



rpm -e XXX #If there is an already installed mariadb, uninstall it



rpm -e --nodeps xxx //If the preceding delete action does not work, try force delete

它确实发挥了魔力。