Asked By
Nichole W
0 points
N/A
Posted on - 03/03/2012
I am trying to establish a connection with MySQL Server in my profile but an error message “Could not connect to the specified instance” with Error No. 2003. I am using a DLink router when connecting. Please help. I am lost right now. Thank you.
MySQL Query Browser Error
Could not connect to the specified instance.
MySQL Error Nr. 2003
Can't connect to MySQL server on '192.168.1.11' (10060)
If you want to check the network connection, please click the Ping button.
OK Ping
Error No. 2003 : Could not connect to the specified instance
Dear Nichole,
The error message 2003 indicates that the network connection has been refused for some reason. Please try to check that there is a MySql server running and its network connections are enabled. Also check that the network port specified is the one configured on the server. Make sure that the server has not been configured to ignore network connections or it has not been configured to listen only locally on the network interfaces. Also check whether there is a firewall blocking the access to Mysql. A detailed explanation of how to do these checks exists in this webpage of mysql: https://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html
Hope this may help you.
Best of luck
Error No. 2003 : Could not connect to the specified instance
The Ping button will only check if the specified IP address can be pinged or not. If the application can ping the IP address then there is still a connection. But if not, the computer assigned to that IP address is offline or can not be reached that’s why you can not connect to the MySQL server. You just need to check your connection, check the settings and determine what seems to be the reason why your computer can not connect to the other server.
If there seems to be no problem with your connection, try uninstalling and then reinstalling the application you are using to fix any corrupted files in the installation and to restore its settings back to default including some of the settings that you might have customized.
Error No. 2003 : Could not connect to the specified instance
Using IIS could be complicated. There is probably wrong to the installation of MySQL to your computer, or you set some security like using password that’s why you can’t connect to it. Why don’t use wamp server. It is very easy to use and very easy to install.
All you need to do is to search wamp server to Google and download it, after download then proceed to installation. No complicated configuration. It installs Apache, PHP5 and MySQL. It allows managing the server easily. After that installation everything will be fine, unlike the one that you are using. For you to solve that, I think you need to re-install or re-configure your server.
Good luck.
