How to use HeidiSQL (or similar MySQL managers) with hosted databases

Question

I use HeidiSQL ( http://www.heidisql.com/ ) to manage my databases at work (I prefer this via phpMyAdmin).

Now I want to use HeidiSQL with my personal host plan, but when I connect to MySQL with my host, I connect to "localhost" in PHP, but at work I connect to databases with something like "supersqlserver.foo". network"...

Is there a way to connect to my hosted database using HeidiSQL? Is it common practice with hosts to allow such software?

By the way, the host where I want to run HeidiSQL is HostGator.

Answer 1

If you cannot connect directly to the MySQL server, for example, the firewall blocks access from all network protocols, with the exception of the HTTP protocol, you can use HTTP tunneling. Here is an example of connecting to MySQl via Httptunnel using HeidiSQL.

Answer 2

Request HostGator support. They should be able to help you. Perhaps they are only listening on the local host, and then you cannot connect from the outside. Quite often, do not listen to external MySQL connections due to security policies, but some hosts allow this.