MySQL error number 2003

Posted on 2005-03-29
Medium Priority
Last Modified: 2011-08-18
I am running MySQL 4.1 on Windows XP professional. I am trying to connect to MySQL administrator. But it is giving the following error when I try to connect:

Could not connect to the specified instatnce.
MySQL error number 2003
Can’t connect to MySQL server on ‘localhost’(10061)

When I run ‘MySQL Command Line Client’ it asks me to enter the password and it takes me to ‘mysql>’.

What do I have to do to connect to MySQL Administrator? Or what am I missing?

The only other thing I have done is I installed MySQL Administrator on my C: drive and MySQL Server on the E: drive. Will that make a difference?

Question by:shamif
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 13655741

it should not matter where you have your database, be it either A:, C: or F:, you did not specify how are you trying to connect to MySQL when it fails neither when it works, if you specify both cases chances are that people here will spot it right away...

Sometimes we get this kind of behaivor because the defaults aren't what we assume they are.

using the mysql database *use mysql* execute the following command....

select User, Host, Password from user;

that will give you a list of users, the host they are authorized to login and the encrypted password, the password could be different for the same user depending on how she/he tries to connect to the database, so, post here both ways you are using to connect to the database and the output from the above command and I am pretty sure you will get a bundle of answers.


Author Comment

ID: 13656093
when I run the select statement I get following results
user : root
host : loacalhost
Password : (an encrypted password)

I am trying to connect to MySQL using 'MySQL Administartor'  and here is what I entered for my connection parameters
connection : MySQL
Username: root
Password: dung
Hostname: localhost
Port : 3306                      Type:MySQL

Author Comment

ID: 13674308
I fixed the problem. From the connection screen I pressed CTRL and pressed 'Skip'. Then from Administrator I stopped the MySQL service and started the service whithin MySQL Administrator. Then I open the Administrator again it worked. I didn't know it was that easy.

Accepted Solution

Computer101 earned 0 total points
ID: 15710749
PAQed with points refunded (125)

EE Admin

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question