CentOS7安装MySQL-5.7.36-yum方式

一、卸载mariadb

1. 查看mariadb和MySQL当前安装列表

rpm -qa|grep mariadb

rpm -qa|grep mysql

2. 卸载

rpm -e --nodeps mariadb-xxx

二、下载MySQL的yum源

1. 查看是否安装wget

rpm -qa | grep wget

2. 如果没有安装，则安装wget

yum -y install wget

3. 下载mysql的repo源（5.7.36）

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

4. 安装repo

rpm -ivh mysql57-community-release-el7-9.noarch.rpm

三、在线安装MySQL

1. 安装

yum install -y mysql-server

如果yum 安装软件出现 gpg keys 相关问题：Public key for *.rpm is not installed

系统中没有能验证该 RPM 数字签名的公钥

安装现有的 gpg 公钥，在 /etc/pki/rpm-gpg/ 下，可以

rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*

直接把所有的都安装

还是不行的话，就通过参数指定不检查数字签名

yum install -y mysql-server --nogpgcheck

2. 启动mysql 服务

systemctl start mysqld

关闭MySQL

systemctl stop mysqld

重启MySQL

systemctl restart mysqld

查看MySQL运行状态

systemctl status mysqld

3. 设置开机启动

systemctl enable mysqld

systemctl daemon-reload

4. 查看root登录密码

vim /var/log/mysqld.log

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

5. 倘若没有获取临时密码，则删除原来安装过的mysql残留的数据

rm -rf /var/lib/mysql

6. 再启动mysql，登录MySQL

mysql -u -p

7. 修改root密码

set password for 'root'@'localhost' =password('Abcd123456!@#$%^');

或

ALTER USER 'root'@'localhost' IDENTIFIED BY ' Abcd123456!@#$%^';

8. 设置root可远程登录

grant all privileges on *.* to 'root'@'%' identified by 'Abcd123456!@#$%^';

9. 退出MySQL登录

exit

10. 关闭防火墙

systemctl stop firewalld.service

11. 禁用防火墙

systemctl disable firewalld.service

12. 启用防火墙

systemctl enable firewalld.service

13. 启动防火墙

systemctl start firewalld.service