Mysql 發生 1130-host {IP} is not allowed to connect to this MySQL server

1. 改表法
   
   登入 mysql 更改 mysql 資料庫 user 表 host 項, 把 localhost 改成 %
   mysql -u root -p
   USE mysql;
   UPDATE USER SET HOST ='%' WHERE USER='root';
   SELECT HOST, USER FROM USER;
   FLUSH PRIVILEGES;
   
   
2. 授權法 (建議作法)
   
   1. 授權帳號可以由任何地方使用密碼連入
   GRANT ALL PRIVILEGES ON *.* TO '帳號'@'%' IDENTIFIED BY '密碼' WITH GRANT OPTION;
   FLUSH PRIVILEGES;
   
   2. 授權帳號可以由單一IP位置使用密碼連入
   GRANT ALL PRIVILEGES ON *.* TO '帳號'@'192.168.1.10' IDENTIFIED BY '密碼' WITH GRANT OPTION;
   FLUSH PRIVILEGES;
   
   3. 授權帳號可以由單一IP位置使用密碼連入ok資料庫
   GRANT ALL PRIVILEGES ON ok.* TO '帳號'@'%' IDENTIFIED BY '密碼' WITH GRANT OPTION;
   FLUSH PRIVILEGES;
   

參考資料
http://hi.baidu.com/ouanan/blog/item/cfc9a94fce76cb24aec3ab23.html