Error No. 2003 : Could not connect to the specified instance

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

• Status: Open
• Question Views: 3842
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Sharath Reddy

Go To Solution

Answered By tibor.tokie 25 points N/A #92641

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

 

About tibor.tokie

Questions
1

Answers
157

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 03/03/2012
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #92642

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.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 12/24/2013
• Question Category: MySQL Server

Answered By Crag fresh 0 points N/A #92643

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.

About Crag fresh

Questions
1

Answers
135

Best Answers
22

• Vote Up 0 Vote Down

• Posted on - 12/24/2013
• Question Category: MySQL Server