Navicat for MySQL remote connection MySQL database 10061 error issue

When connecting MySQL data remotely using the Navicat for MySQL client software, the connection appears 2003-can ' t connect to the MySQL on ' 192.168.1.2 ' (10061) error, because MySQL does not allow remote connections.

Here's how to modify it:

1: Locate the My.ini file under the server MySQL folder. Modify bind-address=127.0.0.1 to bind-address=0.0.0.0

2: Restart the MySQL service.

Test the connection condition:

"1045-access denied for user ' [email protected] (using Password:no)" will appear if the remote login user is not added to the permissions that all machines can access, which indicates the need to add permissions;

Add the following command:

1) Grant all on * * to username @ "%" identified by "password";

2) flush privileges;

By completing the above steps, you can access the MySQL database remotely.

Navicat for MySQL remote connection MySQL database 10061 error issue