centos7安装mysql5.7

1、下载
wget http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql57-community-release-el7-10.noarch.rpm

2、安装
rpm -ivh mysql57-community-release-el7-10.noarch.rpm

3、再安装
yum install -y  mysql-community-server

4、启动
systemctl start mysqld.service

5、获取root密码
grep 'temporary password' /var/log/mysqld.log
# 此时会显示：（2019-06-28T08:52:53.755157Z 1 [Note] A temporary password is generated for root@localhost: 5MYG*b<:hshL），其中5MYG*b<:hshL就是root的密码

6、修改root密码为Root_12345678（mysql -uroot -p）
alter user 'root'@'localhost' identified by 'Root_12345678';
flush privileges;

7、允许外网访问
grant all privileges on *.* to  'root'@'%' identified by 'Root_12345678' with grant option;
flush privileges;

8、添加用户（admin为用户名，Root_12345678为密码）
create user 'admin'@'%' identified by 'Root_12345678';
grant all on *.* to 'admin'@'%' with grant option;
flush privileges;

9、没了
=============OK完毕============

# 启动
systemctl start mysqld.service
# 停止
systemctl stop mysqld.service
# 重启
systemctl restart mysqld.service
# 状态
systemctl status mysqld.service
# 开机启动
systemctl enable mysqld.service

配置文件位置：/etc/my.cnf

# 禁用密码检测，不在乎密码强度
在my.cnf中的[mysqld]下面添加： validate_password=off ,重启即可