I've verified 7 ways from Sunday that mysql service is running and listening on port 3306.
I have ActivePorts, which is a live monitor of connections on your windows machine. Mysql and mysql-nt are listening on their default ports.
I'm not sure what I did over the past few month since I have not connected to the command line, but I can't seem to connect.
I installed drupal and was able to install (create DB) during which time I was not able to command-line in.
I uninstalled mysql and reinstalled on a completely different hard drive/directory. Same issue.
I've googled all I could but my problem is unique but error message is not.
So when you see this error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
You do the following steps:
1. Check MySQL service is running.......CHECK!
2. Check that it's listening on some port ....3306 CHECK!
3. Try to telnet on that port.....OOPS!
Can't telnet. Don't know why? I'm out of ideas guys. MySQL is started and listening on port 3306, why can't I connect to it?
Thanks for any help,
Dan