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)
SQL Error: Can't connect to MySQL server on 'Random IP Address' (10060)
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.
In case you're on WinXP you have telnet.exe, and could do this in a "DOS" box:
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.
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.
Please login to leave a reply, or register at first.