MySQL Forums
Forum List  »  MySQL Administrator

Re: ERROR 2003: Can't connect to MySQL server (10060)
Posted by: Steve Perjesi
Date: May 27, 2007 01:57PM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: ERROR 2003: Can't connect to MySQL server (10060)
May 27, 2007 01:57PM
August 24, 2007 01:26AM
October 16, 2007 07:54AM
October 18, 2007 03:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.