Host is not allowed to connect to this MySQL server

Host is not allowed to connect to this MySQL server

数据库远程连接出现Host is not allowed to connect to this MySQL server解决方法。

解决方法

1. 服务器内mysql系统目录下的/bin文件下执行./mysql -u root -p;输入密码登入mysql
2. 在mysql中执行 use mysql 命令
3. 再执行命令 update user set host = ‘%’ where user = ‘root’;
4. 最后执行 FLUSH PRIVILEGES;