centos7 安装和配置 Mysql5.7

1、安装wget

yum -y install wget

2、下载并安装MySQL官方的 Yum Repository

 wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql-community-server

3、启动MySQL

systemctl start  mysqld.service

#查看MySQL运行状态

systemctl status mysqld.service

4、找出此时root用户的密码

grep "password" /var/log/mysqld.log

#显示内容 红色部分就是密码
[Note] A temporary password is generated for root@localhost: I:9EpMokwA&o

5、输入密码进行登陆并修改密码

mysql -uroot -p

#因为Mysql密码规则默认要求比较高，需要先降低密码要求，才好修改为简单密码
#修改密码规则
set global validate_password_policy=0;
#修改密码长度
set global validate_password_length=1;

#修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

6、修改为允许远程登陆

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

flush privileges;

7、卸载  因为安装了Yum Repository，以后每次yum操作都会自动更新，需要把这个卸载掉

yum -y remove mysql57-community-release-el7-10.noarch