问题：host ‘XXX.XXX.XXX.XXX‘is not allowed to connect to this MySQL server
解决办法：
进入远程mysql #mysql -u root -p mysql> use mysql; Database changed //查看用户 mysql> select host,user from user;
如果没有‘%’需要添加
mysql -u root -p mysql>use mysql; mysql>update user set host =’%‘where user =’root’; mysql>flush privileges;
如果有则直接
mysql>flush privileges;原文：http://www.cnblogs.com/xiaoyaodijun/p/6120290.html