• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 17868
  • Last Modified:

MySQL error number 2003

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?

  • 2
1 Solution

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.

shamifAuthor Commented:
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
shamifAuthor Commented:
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.
PAQed with points refunded (125)

EE Admin

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now