ERROR 1130: Host ... is not allowed to connect to this MySQL server
说明所连接的用户帐号没有远程连接的权限，只能在本机(localhost)登录。 需更改 mysql 数据库里的 user表里的 host项
把localhost改称%
具体步骤：登陆到MySQL 首先 use mysql；

use mysql；

mysql> select host from user where user = 'root';

查看下数据库的host信息如下：

mysql> select host from user where user = 'root';
+------+
| host |
+------+
| %    |
+------+
1 row in set (0.00 sec)

mysql> update user set host=‘%‘ where user = ‘root‘;

ERROR 1062 (23000): Duplicate entry ‘%-root‘ for key ‘PRIMARY‘

最后

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)