Re: ERROR 2003: Can't connect to MySQL server (10060)

[Steve Perjesi]

I had a similar problem and found the answer in my my.cnf file. First of all, my startup script referenced a different my.cnf file other than the one located in /etc/my.cnf (thats what happens when more than one person works on the db). My startup script referenced a file located here in /etc/mysql/debian.cnf.

Under the [mysqld] settings, there is a line that looks like this:

bind-address = 127.0.0.1

This line will make it so ONLY the localhost can connect to the database. A great security feature, but this prevents anyone trying to connect outside the server not to see a database running. I commented out the line, restarted mysqld, and worked like a charm.