MySQL connection error: 1130-host. is not allowed to connect to this MySQL server how to handle

The problem is that the database server in the MySQL database in the user's table does not have the permissions (also can say that no users), the following will be logged I encountered the problem of the process and the way to resolve.

Error connecting with Navicate after setting up LNMP environment

　　

Encounter this problem first to the server on which MySQL is located to process with a connection

　　Connection server: Mysql-u root-p

　　

　　View all current databases: show databases;

　　

　　Go to MySQL database: use MySQL;

　　

　　View all tables in the MySQL database: show tables;

　　

　　View data in the user table: Select Host, User,password from user;

　　

　　Modify Host:update user set host= '% ' where user= ' root ' in the user table;

　　

　　Finally refresh: Flush privileges;

　　

Test again in Navicate:

　　

Reference from: http://www.cnblogs.com/xyzdw/archive/2011/08/11/2135227.html;

Reprint please mark "reprint from Http://www.cnblogs.com/Bighua/p/7629082.html" in the article prominent place

MySQL connection error: 1130-host. is not allowed to connect to this MySQL server how to handle