HeidiSQL & HTTP Tunnel - it works!

Tuesday, 12 April 2011 23:52
User Rating: / 6

HeidiSQL&HTTP Tunnel

HeidiSQL is good and for someone simply irreplaceable tool for working with databases MySQL. This GUI has everything you need to work with the MySQL database. But HeidiSQL missing important functionality is the connection through the HTTP tunnel.

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.

When you can't connect to the MySQL server directly, for example a firewall blocks the access from all network protocols, except HTTP protocol, you can use HTTP tunneling.

In this article I'll show you how to connect to remote MySQL server using HeidiSQL via HTTP Tunnel.

As mentioned earlier HeidiSQL not support connection via Http tunnel, so I used HTTPtunnel GNU package for the organization HTTP tunnel with web server where the MySQL server.

1. Install HTTPTunnel GUI server and the PHP script.

Download phpserver.zip and upload this file on the your hosting, then extract phpserver.zip. The result: phpserver folder on your hosting.

To verify you can open HTTPTunnel control panel by typing in the browser URL:



If you want to configure authentication, logging and other options, you must open your control panel _http: / / your_domain.com / phpserver / admin.php and configure. You can just manually change the file cfg.php. For authorization is necessary to rename the file htaccess.txt to .htaccess.

In this example, all default.

2. Install HTTPTunnel Client. Just run and install file package: HTTPTunnel_1.2.exe

Install HTTPTunnel


HTTPTunnel client


3000 -> 3306
usually your_remote_mysql_server = localhost( because MySQL server is located on the same server where the Web site.

tunnel client


This means all requests to localhost port 3000 will be redirected through HTTP-Tunnel on port 3306 of your database server.


3. Configuring connections HeidiSQL.

Now to connect to remote MySQL server using HeidiSQL specify localhost: 3000. Other settings you should be aware of.

Heidisql http tunnel