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?
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?
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.