不允许1130连接mysql_ERROR 1130(HY000)：主机”不允许连接到此MySQL...

参见英文答案 > Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server????????????????????????????????????24个

为什么哦为什么我不能连接到mysql？

mysql -u root -ptest101 -h xxx.xxx.xxx.xxx

ERROR 1130 (HY000): Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server

在my.cnf我有以下内容

# Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

bind-address = 0.0.0.0

我也跑了以下……

'UPDATE mysql.user SET Password = PASSWORD('test101') WHERE User = 'root';

FLUSH PRIVILEGES;

我可以使用mysql -u root -ptest101在主机上访问但不能使用mysql -u root -ptest101 -h xxx.xxx.xxx.xxx

哇…为什么会这样？我是ubuntj 12.04

mysql> SELECT host FROM mysql.user WHERE User = 'root';

+---------------------------------------------+

| host |

+---------------------------------------------+

| % |

| 127.0.0.1 |

| ::1 | |

| localhost |

+---------------------------------------------+

5 rows in set (0.00 sec)