If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Error 2003 (10060) connecting to remote MySQL server

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-12-05, 18:36
nickmack nickmack is offline
Registered User
 
Join Date: Oct 2005
Posts: 1
Error 2003 (10060) connecting to remote MySQL server

I am running MySQL 4.1.12a on a Win2k Server machine.

I keep getting the 10060 error when trying to remotely log in with a user
'nick' I have set up. I can log in locally on this machine specifying 'localhost' using both 'root' and 'nick'.

This server is located on another network behind a firewall. Access to port
3306 has been granted and upon checking the firewall logs, the packets are
being allowed through. I have also installed port monitor and packet
sniffing software on the server and it shows port 3306 as listening and
whilst trying to connect I can see that the packets are coming in on port
3306 from my source IP on the packet sniff.

If I try and use the mysql -u nick -h xxx.xxx.xxx.xxx -p command on my
machine then I get asked for the password, then about 20 seconds later it
says: ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10060).

I've tried Telnet xxx.xxx.xxx.xxx 3306 and it just fails saying: Connecting
To xxx.xxx.xxx.xxx...Could not open a connection to host on port 3306 :
Connect failed.

Using MySQLAdministrator returns the same 10060 error as the command line above.

I have checked the mysql.user table and the host,user entries are %,nick and
localhost,root, so I should be able to login from any IP for the user 'nick'
but only that machine for root. I checked skip-networking is not in my.ini.

Is there anything I'm missing, it looks like the connection is definitely
being made to the MySQL server on the port, but MySQL is just ignoring any
requests from the outside world. It's driving me bananas.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On