一看到这个错误:
Host xxx is not allowed to connect to this MySQL server
第一反应应该就是MySQL的远程连接未开启,解决办法如下:
1.在本机命令行登录:
mysql -u root -p
输入密码,登录成功
2.登录mysql后,切换到mysql:
use mysql;
3.执行授权sql:
update user set host = '%' where user = 'root';
4.授权立即生效:
FLUSH PRIVILEGES;