centos7 yum安装mysql

1.安装MySQL官方的Yum Repository

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

2.下载rpm包

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

3.安装mysql

yum -y install mysql-community-server

执行安装服务的时间比较长，耐心等待，中间有一次询问y/n？输入y回车

4.mysql管理命令

启动    systemctl start  mysqld
重启    systemctl restart  mysqld
停止    systemctl stop  mysqld
状态    systemctl status  mysqld

5.启动mysql并查看root初始密码（冒号后面的字符就是密码）

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

6.修改root密码
①登录mysqlmysql -u root -p 粘贴上一步的密码
②设置mysql密码策略

set global validate_password_policy=0;
set global validate_password_length=4;

③修改root密码

 ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

7.如需远程访问，还需要在第六步时执行

任意主机：GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '密码' WITH GRANT OPTION; 
固定ip：GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.49'IDENTIFIED BY '密码' WITH GRANT OPTION; 
刷新权限：FLUSH PRIVILEGES