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

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

一个新手
一个新手Original
2017-10-13 10:23:315097browse

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 illustration  When 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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn