Host is not allowed to connect to this MySQL server

如果你想串連你的mysql的時候發生這個錯誤：
ERROR 1130: Host '210.13.92.66' is not allowed to connect to this MySQL server
請按照如下方法解決:

login as: root ///登陸系統
root@tqwm.cn's password: ///輸入密碼
Last login: Tue Apr 15 14:06:54 2008 from 210.13.92.66
[root@myserver ~]# /usr/local/mysql/bin/mysql -uroot -hlocalhost -p ///登入mysql
Enter password: ///輸入mysql對應使用者的密碼
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 431
Server version: 5.0.58-enterprise-gpl-log Source

Type 'help;' or '\h' for help. Type '\c' to clear the buffer. ///登入成功的提示資訊

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootpasswd' WITH GRANT OPTION; ///輸入這段指令並斷行符號後允許所有用root使用者並且輸入rootpasswd密碼的主機登入該mysql Server 如果將'%'換成'10.1.1.1'那麼只有10.1.1.1的主機可以登陸.
Query OK, 0 rows affected (0.07 sec)

mysql> \q ///退出mysql
Bye
[root@myserver ~]#

另外還有一種方法轉自其他地方

改表法。可能是你的帳號不允許從遠程登陸，只能在localhost。這個時候只要在localhost的那台電腦，登入mysql後，更改 "mysql" 資料庫裡的 "user" 表裡的 "host" 項，從"localhost"改稱"%"

mysql -u root -pvmwaremysql>use mysql;mysql>update user set host = '%' where user = 'root';mysql>select host, user from user;

自己的解決方案：

直接在cmd 下進入mysql\bin 下 運行 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION