centos7的mysql5.7的yum方式安装

centos7的mysql5.7的yum方式安装

1. wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2. yum -y install mysql57-community-release-el7-10.noarch.rpm
3. yum -y install mysql-community-server
4. 启动：systemctl start mysqld.service
5. 查看状态：systemctl status mysqld.service
6. 查看初始密码：grep “password” /var/log/mysqld.log
   切换到mysql操作界面:mysql -uroot -p
7. 调整可以设置简单密码：mysql> set global validate_password_policy=0;
   mysql> set global validate_password_length=1;
8. 设置密码：mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘root’;
9. 卸载yum操作自动更新：yum -y remove mysql57-community-release-el7-10.noarch
10. 远程登录：
    1. 开启端口
    2. 修改mysql权限表
       mysql> use mysql;
       mysql> select host,user from user;
       mysql> update user set host=’%’ where user=‘root’;
       mysql> flush privileges;

注意: 防火墙及端口操作请查看 防火墙及端口操作