When Navicat for MySQL connects to the mysql database, the following error occurs: Can & #39; t connect to MySQL server (10060 ),

When Navicat for MySQL connects to the mysql database, the following error occurs: Can't connect to MySQL server (10060 ),

Some problems may be caused by the following reasons:

1. The network is disconnected;

2. The service is not started;

3. Firewall ports are not open;

A) check that the mysql configuration is correct and enable it correctly.

Service mysqld start;

Set mysql remote connection Permissions

Use mysql; update db set host = '%' where user = 'username'; (if it is written as host = localhost, this user does not have the remote access permission) flush privileges; grant all privileges on *. * to 'root' @ '%' identified by 'root' with grant option

B) Open the firewall port:

/Sbin/iptables-I INPUT-p tcp -- dport 3306-j ACCEPT # Add the port to be listened on

/Etc/init. d/iptables save # save settings

C) Security Group of the development service provider, downlink or inbound rules, save and restart the mysql Service