Can't connect to MySQL server on 'localhost' (10061)

mysql localhost mysql5 windows-firewall
Cameron A. Ellis picture Cameron A. Ellis · Sep 23, 2008 · Viewed 486.5k times · Source

I recently installed MySQL 5 on Windows 2003 and tried configuring an instance. Everything worked fine until I got to "Applying Security settings", at which point it gave me the above error (Can't connect to MySQL server on 'localhost' (10061)).

I do have a port 3306 exception in my firewall for 'MySQL Server'.

Answer

ryanjones picture ryanjones · Oct 11, 2011

Got this error on Windows because my mysqld.exe wasn't running.

Ran "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --install from the command line to add it to my services, ran services.msc (start -> run), found the MySQL service and started it.

Didn't have to worry about it from there on out.

Related questions

Can't connect to MySQL server on '127.0.0.1' (10061) (2003)

I know this question was asked a lot before but I tried some of the solutions which were given and nothing worked.. I have downloaded MySQL Workbench 6.1 on my windows 7 x64 and now as I want to start and do …

Read More
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6 Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:\Users\…

Read More
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

This might seem redundant but I was unable to find a correct solution. I was unable to login to mysql using the mysql console.It is asking for a password and I have no clue what I actually entered.(Is …

Read More