How to fix Navicat error, "2003 - Can't connect to MySQL server localhost (10061)"?

[Suzanne Montz]

I am working in Talend Open Profiler software, and checking tables in Navicat Lite.

A few days ago, one of the created MySQL servers gave the message error 2003 - Can't connect to MySQL server localhost (10061).

Now all three of the created servers say the same thing.

The last error message showed today when I opened a table and clicked on the 'go to last page' arrow at the bottom of the window. How do I correct this connection? I tried to build an new connection using the 3306 port we usually use, but it did not work.

Thanks for any input you may have. Our network guy did not know how to fix.

[mwasif]

The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server.

Here is the complete details on MySQL Manual

[vikasmorror]

@mwasif
Open your "localhost"
Then open Remote MySql
There you will see your class c ip add it.
Now, again try Navicat, you can use it.

The problem exist because your hostsite database gives access only registered ip,s and with the help of Remote Mysql you can add ip which can access database.