MySQL 1130 Error

The following error message is displayed: mysql1130error.jpg

 

 

Cause: Unable to connect to the data volume of the MySQL server using the program.

 

Solution: Doscommand

Cd c: \ mysql \ bin

C:

Mysql-u root-P

Mysql> use MySQL; select MySQL DATA SOURCES

Mysql> select host from user where user = 'root'; view the host value in the User table (the host/IP name of the host that can be accessed by the following line can be entered)

Mysql> Update user set host = '%' where user = 'root'; modify the host value (add the host/IP address as the content of the wildcard %)

Mysql> flush privileges; refresh the MySQL system permission related table

Mysql> select host from user where user = 'root ';