1130 - Host ‘***‘ is not allowed to connect to this MySQL server

1130 - Host ‘***’ is not allowed to connect to this MySQL server的解决办法

报错原因：此时的MySQL配置不支持远程连接
解决办法：修改配置

1.linux进入数据库

mysql -u root -p 密码

2.查看配置

select host, user from user;

3.修改配置

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

4.执行以下命令使之生效

flush privileges;

修改完成，可以连接