Unable to connect to a remote MySQL server !

[expired user #10137]'s profile image [expired user #10137] posted 7 years ago in General Permalink

I am trying to connect to remote MySQL server.But even after entering all the setting correctly.I get error "Unable to connect to MySQL server on sql6.freemysqlhosting.net" I have opened both incoming and outgoing port 3306.If I enter same settings in MySQL workbench.I am able to connect to the remote server.Can someone tell what might be the problem with HeidiSQL?

kalvaro's profile image kalvaro posted 7 years ago Permalink

If you really have a local firewall that restricts outgoing connections it's very unlikely that allowing the remote port will make any difference. You either have to allow whatever random local port HeidiSQL chooses every time (there's no way to tell MySQL to use a given port or port range) or most likely allow explicitly the "heidisql.exe" executable (as in the case of Windows integrated firewall). Check your firewall documentation for the details.

[expired user #10137]'s profile image [expired user #10137] posted 7 years ago Permalink

But then how is MySQL workbench able to connect to the server?

kalvaro's profile image kalvaro posted 7 years ago Permalink

I don't know what firewall you are using or how it works. (The Windows firewall I use is smart enough to know that if you allow "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" it shouldn't let "C:\Program Files\HeidiSQL\heidisql.exe".)

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