centos7.9 安装mysql5.7

安装前检查

1、先检查是否已安装过

rpm -qa |grep mysql

2、如果安装过，需删除之前的版本（谨慎操作，先确定是否可以删除）

rpm -e mysql-community-common-5.7.34-1.el7.x86_64
rpm -e mysql-community-server-5.7.34-1.el7.x86_64
rpm -e mysql-community-libs-5.7.34-1.el7.x86_64
rpm -e mysql-community-libs-compat-5.7.34-1.el7.x86_64
rpm -e mysql57-community-release-el7-11.noarch
rpm -e mysql-community-client-5.7.34-1.el7.x86_64

开始安装

1、下载安装包，如果没有安装wget，请安装，步骤略

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

2、安装MySQL源

yum -y localinstall mysql57-community-release-el7-11.noarch.rpm

3、安装MySQL

yum -y install mysql-community-server --nogpgcheck

4、启动mysql 服务

systemctl start mysqld

5、设置开机启动

systemctl enable mysqld
systemctl daemon-reload

6、修改root登录密码

vim /var/log/mysqld.log

找到root@localhost:后面的密码，copy下来

7、登录mysql

mysql -u root -p

8、修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql';

9、设置远程访问，刷新权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
FLUSH PRIVILEGES;