Host 'xx.xx.xx.xx' is not allowed to connect to this MySQL server

解决办法：命令行进入Mysql所在服务器中，执行下面三行语句：

use mysql;
update user set host ="%" where user ="root";
flush privileges;

效果如图所示：