mysq5.7l安装 Install Using Yum [centos7] 2022-12-14

先安装yum-utils

yum -y install yum-utils

先安装这个工具，否则下面需要执行到的命令 yum-config-manager 无法执行。

卸载之前残留的mysql以及mariadb

若mysql正在运行，先停止运行mysql

systemctl stop mysqld

检查是否有安装过mariadb

rpm -qa | grep -i mariadb

若检查到有，则反向安装，即卸载mariadb，–nodeps表示不检查mariadb的依赖单纯卸载mariadb

rpm -e --nodeps [上述查出来的包名]

检查是否有安装过mysql

rpm -qa | grep -i mysql

依次卸载mysql包

rpm -e --nodeps [查出来的包名]

检查mysql以及mariadb的文件夹

find / -name mysql
find / -name mariadb

对查出来的文件夹使用rm -rf 文件夹 删掉
检查系统文件cd 到/etc 文件夹下是否还有my.cnf 配置文件，若有，也使用删除命令删掉

查看你的Linux内核版本

执行命令：

cat /proc/version
或者
hostnamectl

得出结果：

[root@hostname ~]# cat /proc/version
Linux version 3.10.0-693.2.2.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-16) (GCC) ) #1 SMP Tue Sep 12 22:26:13 UTC 2017
[root@hostname ~]# hostnamectl
   Static hostname: hostname 
   Pretty hostname: hostname 
Transient hostname: hostname 
         Icon name: computer-vm
           Chassis: vm
        Machine ID: dfsafgfdgdfgfdg
           Boot ID: b54d00b56fgfdgfdgdfgsds
    Virtualization: kvm
  Operating System: CentOS Linux 7 (Core)
       CPE OS Name: cpe:/o:centos:centos:7
            Kernel: Linux 3.10.0-693.2.2.el7.x86_64
      Architecture: x86-64

看出内核为：el7
根据内核下载对应版本！！

下载对应版本rpm包

在mysql官网yum安装的下载页https://dev.mysql.com/downloads/repo/yum/
选择对应的版本：

Red Hat Enterprise Linux 7 / Oracle Linux 7
(Architecture Independent), RPM Package
(mysql80-community-release-el7-7.noarch.rpm)

下载方式：

1. 直接在上述页面下载到本地，然后上传到服务器对应的文件夹
2. 直接在服务器命令窗口使用wget命令下载，使用wget命令的下载地址为：wget http://repo.mysql.com/mysql80-community-release-el7-7.noarch.rpm

下载的文件，文件名如：mysql80-community-release-el7-7.noarch.rpm

添加mysql到yum的安装库

rpm -Uvh mysql80-community-release-el7-7.noarch.rpm

查看mysql的发布系列

yum repolist all | grep mysql

得出结果如下：

mysql-cluster-7.5-community/x86_64           MySQL Cluster 7.5 C disabled
mysql-cluster-7.5-community-source           MySQL Cluster 7.5 C disabled
mysql-cluster-7.6-community/x86_64           MySQL Cluster 7.6 C disabled
mysql-cluster-7.6-community-source           MySQL Cluster 7.6 C disabled
mysql-cluster-8.0-community/x86_64           MySQL Cluster 8.0 C disabled
mysql-cluster-8.0-community-debuginfo/x86_64 MySQL Cluster 8.0 C disabled
mysql-cluster-8.0-community-source           MySQL Cluster 8.0 C disabled
mysql-connectors-community/x86_64            MySQL Connectors Co enabled:    206
mysql-connectors-community-debuginfo/x86_64  MySQL Connectors Co disabled
mysql-connectors-community-source            MySQL Connectors Co disabled
mysql-tools-community/x86_64                 MySQL Tools Communi enabled:     94
mysql-tools-community-debuginfo/x86_64       MySQL Tools Communi disabled
mysql-tools-community-source                 MySQL Tools Communi disabled
mysql-tools-preview/x86_64                   MySQL Tools Preview disabled
mysql-tools-preview-source                   MySQL Tools Preview disabled
mysql57-community/x86_64                     MySQL 5.7 Community disabled
mysql57-community-source                     MySQL 5.7 Community disabled
mysql80-community/x86_64                     MySQL 8.0 Community enabled:    367
mysql80-community-debuginfo/x86_64           MySQL 8.0 Community disabled
mysql80-community-source                     MySQL 8.0 Community disabled

一般情况下，mysql 默认会让你优先安装8.0版本，如上：

MySQL 8.0 Community enabled:

MySQL 8.0 Community是enabled的状态，而MySQL 5.7 Community disabled 是disabled的状态。
所以要修改一下，执行命令：

yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community

此时再执行yum repolist all | grep mysql 就可以看到mysql5.7是enabled的状态了。

安装mysql

执行命令：

yum install mysql-community-server

会经过几个【y/d/n】，直接yes

启动服务：

systemctl start mysqld

查看临时密码：

grep 'temporary password' /var/log/mysqld.log

用临时密码登陆mysql，且修改root密码

mysql -uroot -p

 ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

完结！