distal-attribute
distal-attribute
distal-attribute
distal-attribute

SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060)

User, date Message
Written by xrader00
5 years ago
Category: Creating a connection
7 posts since Fri, 12 Mar 10
Hello,

I am trying to connect to my friends database (remote access), but i get this error (SQL Error: Can't connect to Mysql.. etc...). I have tried connecting to my localhost, which obviously can not connect because i have no MySQL or anything of that sort for it to connect to.

The part i do not understand is, why can't i connect to my friends server. He confirms to me that everything is correct on his side, and that the problem must be on my computer. Im guessing i do not have MySQL running as when i try to connect it says 'not responding' in my task manager.

Please help me, i'd GREATLY appreciate the help. smile
I just got my computer fixed (from a bug), but MySQL worked on my last computer. (If that has anything to do with the problem)
Written by xrader00
5 years ago
7 posts since Fri, 12 Mar 10
As a side note, No I am not using "Random IP Address" as my ip/host. (laughs)
Written by ansgar
5 years ago
5023 posts since Fri, 07 Apr 06
That can easily be caused by your friend's MySQL set up, but surely also by a firewall blocking HeidiSQL or his MySQL. Just make sure you have the 100% right ip address or host name. If just the username/password is wrong the error message sounds different from the one you cited above.
Written by xrader00
5 years ago
7 posts since Fri, 12 Mar 10
I dont think the Username and Password is the problem. I think it might be like what you said; but still, i dont know why it would act up. I added HeidiSQL and port 3306 as exceptions in my firewall. What else might be causing this?
Written by ansgar
5 years ago
5023 posts since Fri, 07 Apr 06
In case you're on WinXP you have telnet.exe, and could do this in a "DOS" box:

telnet YourFriendsIP 3306


This opens a raw connection to your friend's MySQL server on port 3306. Although telnet cannot do anything with MySQL, it will indicate a successful connection: watch for a MySQL version string in the first output lines, e.g. I got "5.0.67-community-log" plus some garbage chars. If you do not get such a version, your connection is definitely blocked somewhere.
Written by xrader00
5 years ago
7 posts since Fri, 12 Mar 10
Unfortunately, i got this message "Could not open connection to the host, on port 3306: Connection Failed"

According to your previous response, this means that my connection is blocked somewhere. Is the problem on his end or my computer?
Written by ansgar
5 years ago
5023 posts since Fri, 07 Apr 06
That just tells that the connection cannot be established - not a word about the location of the blocker. Tell your friend and ask him if he got a firewall?
Written by xrader00
5 years ago
7 posts since Fri, 12 Mar 10
He does have a firewall.
Written by ansgar
5 years ago
5023 posts since Fri, 07 Apr 06
So, could he solve your problem?
Written by xrader00
5 years ago
7 posts since Fri, 12 Mar 10
I think he is going to have to, but thats the thing; neither of us really know how we can even start to try and fix the problem.
Written by ansgar
5 years ago
5023 posts since Fri, 07 Apr 06
Well you say he has a firewall - that's the point where you can start looking for the problem, isn't it?
Written by xrader00
5 years ago
7 posts since Fri, 12 Mar 10
Yes, im thinking the problem might be on my computert because no matter what my friend changes, it still says that HeidiSQL is 'Not Responding' in my Windows Task Manager.

This is very frustrating unhappy
Written by ansgar
5 years ago
5023 posts since Fri, 07 Apr 06
Not responding ? Give it at least a 30 seconds timeout to decide if it's dead. However, sounds like some blocker on your machine.
 

Please login to leave a reply, or register at first.