MySQL 10060 remote cannot access

1. The network does not pass.

Check to be able to ping through.

2. Firewall settings.

Whether the firewall has spared the MySQL process, whether to block the MySQL Port 3306.

Account settings for 3.mysql.

Whether the MySQL account does not allow remote connections. If you cannot connect, you can try the following methods:

Mysql-u root-p//login MySQL

Mysql> Grant all privileges on * * to ' root ' @ '% ' with GRANT OPTION; Any remote host can access the database

mysql> FLUSH privileges; You need to enter a secondary command to make the changes effective

Mysql> Exit//exit

>>>>>> can also be implemented remotely by modifying tables:

Mysql-u root-p

mysql> use MySQL;

mysql> Update user Set host = '% ' where user = ' root ';

Mysql> Select Host, user from user;

MySQL 10060 remote cannot access