MySQL Forums
Forum List  »  MySQL Administrator

Re: ERROR 2003: Can't connect to MySQL server (10060)
Posted by: Michael Kay
Date: December 14, 2005 10:40AM

10060 is the error number not the port so no need to open that up on the firewall.

3306 is the standard port for connecting to mysql.

Check that skip_networking isn't on by running SQL Query

SHOW VARIABLES LIKE "SKIP%"

locally to the machine... If it is ON then turn it OFF. This can only be done in the config file and just means commenting out the skip_networking line. Also check that the port for networking is 3306 while your there.

Also check that mysql.sock is listening on 3306 using netstat from a console on the machine locally.

Check your firewall allows port 3306 to connect to your machine. This will depend on the firewall your using.

Options: ReplyQuote


Subject
Written By
Posted
Re: ERROR 2003: Can't connect to MySQL server (10060)
December 14, 2005 10:40AM
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.