The host field represents the logged-on hosts, whose values can be either IP-enabled or host-name, (1Sometimes you want to log in with a local IP, you can change the above host value to your own IP. If the above approach doesn't work, we can turn on MySQL remote access permission to allow remote connections 1, log in to MySQL database code as follows copy codeMysql-u Root-P View the user table code as follows to copy the codeMysql>UseMysql D Atabase changedMysql> Select Host,user,Password from user +-+-+-+| Host | user | Password |+-+-+-+| localhost | Root | *a731aebfb621e354cd41baf207d884a609e81f5e | | 192.168.1.1 | Root | *a731aebfb621e354cd41baf207d884a609e81f5e |+-+-+-+2 Rows in Set (0.00SEC) to see the root user that was created in the user table.

Test connectivity: If you do not add permissions to remote login users for all machines, you will see '1045-access deniedfor user (using password:NO) ', which indicates the need to add permissions Add a command as follows: code to copy Code 1) grant all on * * to User name 'identified by' password ' 2)Flushprivileges Complete the above steps, you can access the MySQL database remotely. Modify bind-address=127.0.0.1 for bind-address=0.0.0.0 (my in MySQL 5.INI, this is not found) 2: Restart the MySQL service. Open Port 3306, set an exception for the firewall, and release 3306.But you have to have root authority, you can also modify the following methods: 1: Locate the My.ini file under the server MySQL folder. The simplest way to do this is to copy the code below the MySQL remote Configuration Code grant all privileges on * * to '% ' identified by ' your password ' %Indicates that there are many machines. Using Navicat to connect remote MySQL data error:Ī friend may come across the use of navicatForMySQL remote connection MySQL database will prompt 10061, 1045 error or 2003-can ' t connect toMySQL on ' 192.168.1.2 ' (10061),The reason for this is that MySQL does not allow remote connections.

Navicat 1045