Today 1 netizens ask for help, said oneself phpMyAdmin can connect the database normally, use SQLyog error:
ERROR 1130:host ' 172.27.214.1 ' isn't allowed to connect to Thismysql server
Root Case:mysql default All accounts are not allowed to log in remotely, only on localhost
Workaround:
1, modify the user table
Mysql-u root-p
Mysql>use MySQL;
Mysql>update User Set host = ' 172.27.241.1 ' where user = ' root ';
Mysql>flush privileges;
2. Specify authorization
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;
Attention:
1. Precise authorization, that is, the account, which host, what kind of authority is required, it must be stated, preferably not pan-authorized;
2. Remember to flush the privileges after each command is executed;
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
ERROR 1130:host ' is not allowed to connect to Thismysql server