MySQL 安装常见错误

1. 版本冲突

Error : mysql57-community-release conflicts with mysql80-community-release-el8-1.noarch

分析

安装了其他版本的mysql再安装mysql57的时候依赖出问题

解决

删除老的mysql工具

rpm -Uvh mysql57-community-release-el7-10.noarch.rpm
#命令行出现 mysql57-community-release-el7-8.noarch
rpm -e --nodeps mysql57-community-release-el7-8.noarch

2. 依赖报错

Error: Package: mysql-community-server-5.7.20-1.el7.x86_64 (mysql57-community)
           Requires: libsasl2.so.3()(64bit)
Error: Package: mysql-community-client-5.7.20-1.el7.x86_64 (mysql57-community)
           Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit)
Error: Package: mysql-community-libs-5.7.20-1.el7.x86_64 (mysql57-community)
...

分析

因为 旧版本 mysql 的依赖问题；最快的解决方案就是卸载重装

3. 卸载

1.快速删除

yum remove  mysql mysql-server mysql-libs mysql-server

2.查找残留文件

rpm -qa | grep -i mysql
## 将查询出来的文件删除
yum remove mysql-community-common-5.7.20-1.el6.x86_64
## 删除残余目录
whereis mysql
## mysql : /usr/lib64/mysql
rm –rf /usr/lib64/mysql

3.删除依赖

## 查找依赖 
yum list installed | grep mysql
## 删除找到的依赖
yum -y remove mysql-libs.x86_64

4. 安装新mysql

1.添加镜像源，从官网downloads选取

wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum localinstall mysql-community-release-el6-5.noarch.rpm
yum repolist all | grep mysql
yum-config-manager --disable mysql55-community
yum-config-manager --disable mysql56-community
yum-config-manager --enable mysql57-community-dmr
yum repolist enabled | grep mysql

2.安装

yum install mysql-community-server

本作品采用《CC 协议》，转载必须注明作者和本文链接