cannot connect to MySQL Administrator

[shaminda]

I am running MySQL 4.1 on Windows XP. 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?

 

[dalchri]

Make certain that port 3306 is not blocked by the Windows Firewall under the control panel or any other firewall software that you might have running like Norton.

You can test this by issuing a telnet localhost 3306 at the command prompt. You ought to get a response (albeit garbled) but not a message that says the connection could not be established or rejected.

 

[shaminda]

I get following error when I try to tellnet:

connecting to localhost....Could not open connection to the host, on port 3306: caonnect failed

And my firewall is turned off right now.

 

[dalchri]

The only other thing to do is to make certain that MySQL is running by checking your processes. MySQL-nt.exe should be listed.

You might also try pinging localhost to make certain that it resolves to 127.0.0.1.

If all of those check out, there must be something somewhere blocking access to port 3306 unless you changed the default port number.

 

[shaminda]

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.