MySQL在CentOS 7上安装失败的解决方法

在本文中，我们将介绍在CentOS 7上安装MySQL时可能会遇到的问题以及对应的解决方法。

阅读更多：MySQL 教程

问题描述

在执行以下命令安装MySQL时：

sudo yum install mysql-server

可能会遇到以下错误信息：

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.sohu.com
* extras: mirrors.aliyun.com
* updates: mirrors.163.com
Resolving Dependencies
--> Running transaction check
---> Package mysql-server.x86_64
3.6.1-1.el6 will be installed
--> Processing Dependency: mysql = 3.6.1-1.el6 for package: mysql-server-3.6.1-1.el6.x86_64
--> Processing Dependency: perl-DBI for package: mysql-server-3.6.1-1.el6.x86_64
--> Running transaction check
---> Package mysql.x86_64 3.6.1-1.el6 will be installed
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Finished Dependency Resolution
Error: Package: mysql-server-3.6.1-1.el6.x86_64 (base)
           Requires: mysql = 3.6.1-1.el6
           Installed: mysql-5.6.50-1.el7.x86_64 (@base)
               mysql = 5.6.50-1.el7
           Available: mysql-5.5.52-mysql-5.5.52-1.el6.x86_64 (base)
               mysql = 5.5.52-mysql-5.5.52-1.el6
           Available: mysql-5.5.60-mysql-5.5.60-1.el6.x86_64 (base)
               mysql = 5.5.60-mysql-5.5.60-1.el6
           Available: mysql-5.6.35-1.el6.x86_64 (base)
               mysql = 5.6.35-1.el6
           Available: mysql-5.6.36-1.el6.x86_64 (base)
               mysql = 5.6.36-1.el6
           Available: mysql-5.6.37-1.el6.x86_64 (base)
               mysql = 5.6.37-1.el6
           Available: mysql-5.6.38-1.el6.x86_64 (base)
               mysql = 5.6.38-1.el6
           Available: mysql-5.6.39-1.el6.x86_64 (base)
               mysql = 5.6.39-1.el6
           Available: mysql-5.6.40-1.el6.x86_64 (base)
               mysql = 5.6.40-1.el6
           Available: mysql-5.6.41-1.el6.x86_64 (base)
               mysql = 5.6.41-1.el6
           Available: mysql-5.6.42-1.el6.x86_64 (base)
               mysql = 5.6.42-1.el6
           Available: mysql-5.6.43-1.el6.x86_64 (base)
               mysql = 5.6.43-1.el6
           Available: mysql-5.6.44-1.el6.x86_64 (base)
               mysql = 5.6.44-1.el6
           Available: mysql-5.6.45-1.el6.x86_64 (base)
               mysql = 5.6.45-1.el6
           Available: mysql-5.6.46-1.el6.x86_64 (base)
               mysql = 5.6.46-1.el6
           Available: mysql-5.6.47-1.el6.x86_64 (base)
               mysql = 5.6.47-1.el6
           Available: mysql-5.6.48-1.el6.x86_64 (base)
               mysql = 5.6.48-1.el6
           Available: mysql-5.6.49-1.el6.x86_64 (base)
               mysql = 5.6.49-1.el6
 You could try using --skip-broken to work around the problem
 You couldalso try running: rpm -Va --nofiles --nodigest

即因为CentOS 7默认的MySQL版本与要安装的MySQL版本不一致，导致安装失败。

解决方法

解决这个问题的方法有两种：

方法一

使用官方的MySQL repository，这里是一个CentOS 7的链接。在终端运行以下命令：

sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
sudo yum install mysql-server

该方法会安装最新版本的MySQL，此时MySQL版本为8.0。如果需要安装其他版本的MySQL，可以修改/etc/yum.repos.d/mysql-community.repo文件中的版本号。

方法二

卸载CentOS 7自带的MySQL，并使用官方的MySQL repository安装需要的版本。在终端运行以下命令：

sudo yum remove mysql mysql-server mysql-libs
sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
sudo yum install mysql-server