The error code is 1130,error 1130:host xxx.xxx.xxx.xxx was not allowed to connect to the this MySQL server was unable to give remote connection user rights issue
Navicat for MySQL 1130 error connection with Navicat remote MySQL, prompted the following error, I thought it was my firewall problem, but shut down, still not.
I think this paragraph of English is a bit misleading, which makes people feel that they have a problem on their side.
Let's see how it's solved.
ERROR 1130:host ' 192.168.1.3 ' isn't allowed to connect to Thismysql server
Workaround:
1. Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", 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 to myuser use MyPassword to connect to a MySQL server from any host.
GRANT all privileges on * * to identified by ' MyPassword ' withgrant OPTION;
If you want to allow users to connect to the MySQL server from a host myuser IP 192.168.1.3 and use MyPassword as the password
GRANT all privileges on *. * to identified by ' MyPassword ' with GRANT OPTION;
Method Two:
The error code is 1130,error 1130:host xxx.xxx.xxx.xxx was not allowed to connect to the this MySQL server was unable to give remote connection user rights issue
Authorization to the user
The user I use is the root password 123456
The preferred syntax is:
SQL code
GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;
Example:
SQL code
GRANT all privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT OPTION;
After the execution, and then
Mysql:flush privileges;
Just refresh the permissions and don't restart.
Full operation:
Start-to-run->cmd
cd\
cd MySQL installation directory \ Bin
Mysql-u root-p123456;
MySQL GRANT all privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT OPTION;
MySQL flush privileges;
Author Heisetoufa
"Go" error when using Navicat for MySQL remote connection to MySQL 1130 workaround