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.
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.
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
- Start it c:\Program Files\HTTPTunnel\client\httptunnel_client.exe or click Start -> All Programms\HTTPTunnel\HTTPTunnel Client
- Open your Client control panel _http://localhost:1079/ and tune configure portmapping. Add example:
3000 -> 127.0.0.1: 3306
usually your_remote_mysql_server = localhost(127.0.0.1) because MySQL server is located on the same server where the Web site.
This means all requests to localhost port 3000 will be redirected through HTTP-Tunnel on port 3306 of your database server.
- Tunnel Server tab, specify the URL to the PHP-script server side of the tunnel, authorization and proxy (if necessary). _http://your_domain.com/phpserver/tunnel.php
Press Save button.
3. Configuring connections HeidiSQL.
Now to connect to remote MySQL server using HeidiSQL specify localhost: 3000. Other settings you should be aware of.