MySQL Forums
Forum List  »  Perl

Re: ERROR 2003: Can't connect to MySQL server on 'host ip'(10060)
Posted by: Bill Karwin
Date: June 28, 2006 02:56PM

The number 2003 in this case is a MySQL client-side error code; it is only coincedence that it is also the version of your Windows operating system.

90% of the time, this error is due either to the MySQL Server not running, or else firewall configuration on the Windows server blocking access on port 3306 (or whatever port your MySQL instance is configured to use).

Also see http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html

The sequence of messages output from your script suggests that it might be connecting successfully to retrieve the table structure, etc., and only fails when retrieving rows from the SELECT query. But I don't know the code in your script. For instance, it could be retrieving the table structure from a different MySQL instance, or it could be printing all four messages before attempting to connect.

Regards,
Bill K.

Options: ReplyQuote


Subject
Written By
Posted
Re: ERROR 2003: Can't connect to MySQL server on 'host ip'(10060)
June 28, 2006 02:56PM


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.