Link to home
Start Free TrialLog in
Avatar of shamif
shamif

asked on

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?

Avatar of esanchezvela
esanchezvela


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.

regards,
esv.
Avatar of shamif

ASKER

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
Avatar of shamif

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Computer101
Computer101
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial