Can't connect to localhost

[zonkd]

On a new machine, I am trying to get MySql to work.

IIS is up and going, but when I try to get MySql to work its magic it says, in reply to "mysql\bin" then "mysql" Error 2003: Can't connect to MySQL server on 'localhost' (10061).

I've just bought Kevin Yank's gospel and I can't wait to get going ...

[swdev]

That is probably because the MySQL server process has not been started.
try typing net.exe start MySQL from a command prompt. That should display some messages indicating that the service is trying to start, and if it starts, then [b]mysql.exe -u root -p[b] should connect.

[zonkd]

Thanks, swdev. That prompts this message

'system error 5 has occurred. Access is denied.'

Hopefully that reveals something positive...? (Most impressed by your skills, sw. Hope my problem won't seem too puny for you.)

[swdev]

Okay, thanks for the praise

This may help

start a command window
goto your SQL installation directory, and then the bin sub-directory
type mysqld.exe

You should see some messages saying that MySQL is starting up, or some error messages.
If all is well, you will not be returned to a command prompt.

start a second command window
goto your SQL installation directory, and then the bin sub-directory
type mysqladmin.exe -u root -p shutdown
This will shutdown the MySQL server

then type mysql.exe --install-manual. This will install MySQL as a service that can then be started by net.exe start MySQL and stopped by net.exe stop MySQL

If you want to name the service something else, say TestServer, then type mysqld.exe --install-manual TestServer.

Hope this helps

[Sheqel]

thanks, this thread partly helped my problem, I managed to start a second instance of Mysql this way, because the first instance crashed and I can't get it to shutdown, even a reboot won't help.
When I try to start it, it says 'Service already exists' but there is no mysqld in my task manager. Any idea? Reinstalling doesn't quite work.