How to connect MySQL server?

[xuexuexue]

I run Mysql 4.0.18 on window xp. After I trid the command 'mysqladmin shutdown' , I cannot connect the server again. I restarted the computer, and tried the command 'mysqladmin ping'. The followings showed on the screen:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' <10061>'
check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'


Then I trid the command 'telnet localhost 3306', and get the followings:

Connecting To localhost...Could not open connection to the host, on port 3306: connect failed


I checked the processes in memory. 'mysqld-nt.exe' was on the list. My firewall is Norton 2005. How can I solve the problem?

 

[TonyGroves]

Have you tried killing the process, and re-starting MySQL?

 

[sleipnir214]

It sounds to me like MySQL isn't configured to automatically start on a reboot.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[cyclegeek]

I think I have a similar problem.

I'm using TOAD for MySQL and my error message is:

Unable to connect to any of the specified MySQL hosts

I can connect to a database on a remote server, just not on a database on localhost.

The version of MySQL is 4.1 and is newly installed - TOAD is 5.1 and also newly installed.

Cheers,
cyclegeek