MYSQL Database for remote connection

1, at first I was using the navicat for MySQL tool to connect to the remote MySQL database.

An error has been made. The error message is the error 1130:host ' 192.168.1.80 ' is not the allowed to connect to this MySQL server.

I have a total of two ways to find solutions online:

A. 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 in localhost, after logging in to MySQL, change the "MySQL" Database of the ' User ' table "host" item, from "localhost" renamed "%"

B. Authorization law. Enter in the command tool that mysql1.5.6 comes with

1. Mysql> Grant all privileges on * * to ' root ' @'% ' identified by ' 123456 ' with GRANT option;
2. mysql> flush Privileges; //Refresh permissions, no need to restart MySQL

The method used above is implemented on the remote machine with MySQL installed.

2, and then I use the navicat for MySQL tool locally to connect to the remote MySQL database.

An error has been made. 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.

3, and then I want to use the cmd command to connect to the remote database and not 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 2, which is blocked by the firewall.

4, continue the third, I want to use the MySQL command inside CMD.

Just opened my reference to the method on the Internet. Switch the command directory to the bin directory of the MySQL database. Then use the MySQL command to connect to the MySQL database remotely.

You can refer to the picture for specific actions.

5, but I found that it is not very troublesome to switch to the directory of the MySQL database bin every time?

So, I'm configuring the system path file. The picture below is my system configuration information.

Then I can enter the MySQL command under the path name of the cmd directory.

MYSQL Database for remote connection