Mysql connection error: 1130-host... is not allowed to connect to this MySql server how to handle, 1130-hostallowed

Mysql connection error: 1130-host... is not allowed to connect to this MySql server how to handle, 1130-hostallowed

This problem occurs because the user table in the mysql database on the database server does not have the permission (or even has no user). The following describes how to solve the problem.

An error occurred while connecting with Navicate after LNMP environment was set up.

When this problem occurs, connect to the mysql server for troubleshooting.

Connection server: mysql-u root-p

View all current databases: show databases;

Enter the 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 the Host in the user table: update user set Host = '%' where User = 'root ';

Last Refresh: flush privileges;

Test again in Navicate:

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

For reprinting, please mark "reposted from http://www.cnblogs.com/big#/p/7629082.html" in the article"