A 10061 error occurs when Navicat connects to the local Mysql database, but the connection to the remote database is correct.

There is a 10061 error in connecting Navicat to the local Mysql instance, but there is no problem in connecting to the remote connection. Navicat

BitsCN.com

Some time ago, Navicat suddenly failed to connect to the local MySql, and the error "2003-Can't connect to MySQL on '192. 168.90.165 '(192)" was always displayed. No solution is found. Today, I was just free. I ran to Duniang again and finally solved it!

The 10061 error occurs when Navicat connects to the local Mysql database, but the remote connection is normal. it may be that the wampmysqld service is found in the local service and has been started, but the connection fails. Strange!

Related Solutions found on the website:

1. find the my. ini file in the MySQL folder on the server.
Modify bind-address = 127.0.0.1 to bind-address = 0.0.0.0
If this item is not found in my. ini of MySQL 5, add this line in [mysqld]: bind-address = 0.0.0.0
2. restart the MySQL service. The connection is successful.

BitsCN.com