ERROR 1130: Host '' is not allowed to connect to thisMySQL server，1130thismysql

ERROR 1130: Host '' is not allowed to connect to thisMySQL server，1130thismysql
今天1網友求助，說自己PHPmyadmin可以正常串連資料庫，使用sqlyog報錯：

ERROR 1130: Host '172.27.214.1' is not allowed to connect to thisMySQL server

root case:MySQL預設所有帳號不允許從遠程登陸，只能在localhost
解決方案： 
1,修改user表
mysql -u root -p
mysql>use mysql;
mysql>update user set host = '172.27.241.1' where user ='root';
mysql>flush privileges;
2.指定授權
mysql -u root -p
mysql>use mysql;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.27.241.1' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 

mysql>flush privileges;

注意：

1.精準授權，即那個帳號，哪台主機，需要哪種許可權，必須寫明，最好不要泛授權；

2.記著執行完每條命令要flush privileges;

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。