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?
Unable to connect to a remote MySQL server !
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.
Please login to leave a reply, or register at first.