Direct use of Navicat via IP connection will report various errors, for example: Error 1130:host ' 192.168.1.80 ' is not allowed to connect to this MySQL server.
After personal verification, a solution is obtained, as follows:
Authorization law:
1. First use localhost to log on to the database you want to connect remotely
2. Open the Command Prompt window and enter the following command:
Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ' with GRANT option;
Query OK, 0 rows affected
mysql> flush Privileges;
Query OK, 0 rows affected
The first sentence is the permission of a given remote connection, simply set the user name and password for the connection based on the root of the personal database modification statement and 123456来
The second sentence is to refresh the database so that permissions take effect immediately.
3. In general, the database can be connected remotely, but sometimes the following error occurs: 2003-can ' t connect to MySQL server on ' 192.168.1.80 ' (10038).
The error is that the server (the server is the Win7 system) firewall has blocked your connection. Then shut down the firewall and connect to it.
Use the cmd command to connect to the remote database and not to use any tools to connect to the remote database.
An error has been made in the command line. ERROR 2003
The reason for this error is the same as the firewall interception.
After the above steps for the use of WIN7 to build a local domain, remote connection to the MySQL database on the WIN7 of the small partners, has been able to properly connect the database development.
PS: Turn off WIN7 Firewall in addition to the control Panel off, but also in the service to close
property to Manual, or disable, and then close the service.
MySQL process for remote connection via Navicat