Solution of MySQL 1130 error report when remote connection through Navicat for MySQL

Navicat for MySQL 1130 error: using Navicat to connect to remote mysql, the following error is prompted. I thought it was my own firewall problem, but when it was turned off, it still couldn’t work.

I think this paragraph of English is a bit misleading and makes people feel that there is something wrong with them.

Look at the solution

ERROR 1130: Host ‘192.168.1.3’ is not allowed to connect to thisMySQL server

resolvent:

1。 Change the table method. Maybe your account is not allowed to log in from remote, only in localhost. At this time, just log in to MySQL on the computer of localhost, change the “host” item in the “user” table in the “MySQL” database, and change the name from “localhost” to “%”

mysql -u root -pvmwaremysql>usemysql;mysql>update user set host = ‘%’ where user =’root’;mysql>select host, user from user;

2. Authorization law. For example, if you want myuser to connect to the MySQL server from any host using mypassword.

Grant all privileges on *. * to identified by ‘mypassword’ with grant option; if you want to allow user myuser to connect to MySQL server from the host with IP 192.168.1.3, and use mypassword as password

GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY’mypassword’ WITH GRANT OPTION;

Method 2

The error code is 1130, Error 1130: host xxx.xxx.xxx . XXX is not allowed to connect to this MySQL server

Authorization to users

I use the root password 123456

The preferred syntax is:

SQL code

GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;

Example: