解决连不上ECS的MySQL

1. MySQL 异常: “Host ‘xxx’ is not allowed to connect to this MySQL server”？

# 使用数据库mysql
use mysql;
# 查看主机和用户
mysql> select host, user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.00 sec)

mysql> update user set host = '%' where user = 'root';

mysql> FLUSH PRIVILEGES; 
回车使刚才的修改生效，再次远程连接数据库成功。

.Xqq