云服务器Yum安装mysql5.7并设置远程访问

1
2
3
4
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

1
2
3
systemctl start  mysqld.service
systemctl enable mysqld

1
2
systemctl status mysqld.service

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

1
2
mysql -uroot -p

1
2
3
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;

1
2
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '自定义密码';

1
2
3
mysql> use mysql;
mysql> update user set host='%' where user='root' and host='localhost';

1
2
3
4
5
6
7
8
9
10

mysql> select host,user from user;
+-----------+---------------+
| host      | user          |
+-----------+---------------+
| %         | root          |
| localhost | mysql.session |
| localhost | mysql.sys     |
+-----------+---------------+

1
2
3
mysql>flush privileges
mysql> exit;