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

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.
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)

As a side note, No I am not using "Random IP Address" as my ip/host. (laughs)

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.

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?

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.

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?

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?

He does have a firewall.

So, could he solve your problem?

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.

Well you say he has a firewall - that's the point where you can start looking for the problem, isn't it?

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

Not responding ? Give it at least a 30 seconds timeout to decide if it's dead. However, sounds like some blocker on your machine.