Host is not a allowed to connect to this MySQL server solution can access the local area network database! Perfect solution!

0.

http://blog.csdn.net/flyyhz/article/details/77100243

1.

2.

3.

4.

5.

6.

7.

8.

9.

Today on Linux installed MySQL, but found in the local login can, but remote login but error Host is not allowed to connect to this mysql server , find a half-day to try some of the online methods are not resolved, and finally found a solution in an article, deliberately recorded.

First of all, the error is that our MySQL is not allowed to Telnet, so telnet failed, the workaround is as follows:

1. Log on to the MySQL mysql-u root-p password on the MySQL-equipped machine
2. Performuse mysql;
3. Execution update user set host = ‘%‘ where user = ‘root‘; of this sentence may be an error, do not care about it.

4. PerformFLUSH PRIVILEGES;

   After 4 steps above, you can solve this problem.
   Note: The fourth step is to refresh the MySQL permissions related tables, must not forget, I did not perform the first time fourth step, the results have been unsuccessful, finally found this reason.

Host is not a allowed to connect to this MySQL server solution can access the local area network database! Perfect solution!