Mysql error: 1130-host ... is not allowed to connect to this MySql server How to deal with it

This problem is because there is no permission in the user table in the mysql database in the database server (it can also be said that there is no user). The following will record the process of the problem I encountered and the solution.

An error occurred when using Navicate to connect after setting up the LNMP environment

When encountering this problem, first go to the server where mysql is located and use a connection to handle it

1.Connect to the server : mysql -u root -p

##　2. View all current databases: show databases;

3. Enter the mysql database: use mysql;

## 4. View all tables in the mysql database: show tables;

## 5. View the data in the user table: select Host, User,Password from user;

##　6. Modify the Host in the user table :update user set Host='%' where User='root';

##　7.Finally refresh: flush privileges;

Be sure to remember to add ";" after the statement is completed when writing sql. The following is an illustrationWhen encountering this problem, first go to the server where mysql is located and use a connection to handle it

Connect to the 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 the 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';

Finally refresh: flush privileges;

　Test again in Navicate:

The above is the detailed content of Mysql error: 1130-host ... is not allowed to connect to this MySql server How to deal with it. For more information, please follow other related articles on the PHP Chinese website!