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

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

xrader00 posted 5 years ago in Creating a connection
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)
xrader00 posted 5 years ago
As a side note, No I am not using "Random IP Address" as my ip/host. (laughs)
ansgar posted 5 years ago
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.
xrader00 posted 5 years ago
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?
ansgar posted 5 years ago
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.
xrader00 posted 5 years ago
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?
ansgar posted 5 years ago
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?
xrader00 posted 5 years ago
He does have a firewall.
ansgar posted 5 years ago
So, could he solve your problem?
xrader00 posted 5 years ago
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.
ansgar posted 5 years ago
Well you say he has a firewall - that's the point where you can start looking for the problem, isn't it?
xrader00 posted 5 years ago
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
ansgar posted 5 years ago
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.