MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Articles HTTP Tunneling HeidiSQL & HTTP Tunnel - it works!

HeidiSQL & HTTP Tunnel - it works!

Print PDF
User Rating: / 24
PoorBest 

HeidiSQL&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.

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.

Useful Articles:
What is HTTP Tunnel?
Install GNU HTTPTunnel package.

//


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:

http://your_domain.com/phpserver/admin.php

Control-panel-httptunnel

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

 

  • Start it c:\Program Files\HTTPTunnel\client\httptunnel_client.exe  or click  Start -> All Programms\HTTPTunnel\HTTPTunnel Client

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.

tunnel client

modify-portmapping

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
  • tunnel server

    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.

Heidisql http tunnel

 

 

Comments 

 
+1 #10 Rudy 2013-10-03 12:11
Thanks, it works!
Quote
 
 
0 #9 Administrator 2012-06-04 21:34
Quoting Barsul:
Hello !
The file phpserver.zip is broken too with :

http://http-tunnel.sourceforge.net/

Can you upload this files plz ?

links updated
Quote
 
 
0 #8 2012-01-09 10:44
Hello !
The file phpserver.zip is broken too with :

http://http-tunnel.sourceforge.net/

Can you upload this files plz ?
Quote
 
 
0 #7 2011-09-27 08:00
Is there possibility to build a tunnel from a c# application? HowTo ?
Quote
 
 
0 #6 2011-09-19 11:47
The link to HTTPTunnel is:
http://http-tunnel.sourceforge.net/
Quote
 
 
0 #5 2011-06-20 16:22
the link to phpserver is broken, and this is my only free option! Anyone have the file?
Quote
 
 
0 #4 2011-01-14 16:08
it work!
Quote
 
 
+1 #3 2010-06-02 22:36
thanks! very useful
Quote
 
 
+5 #2 2010-03-19 17:19
I for the tunnel connection to the database just use SqlYog with the one supplied SQLyogTunnel.php. Very convenient:)
Quote
 
 
+11 #1 2010-03-18 12:27
HEIDISQL my favorite tool, I use it very long time, and now with HTTP tunnel! Thanks!
Quote
 

Add comment


Security code
Refresh

mysql tools

Tunnel-heidisql

-

 

 

I used HTTPtunnel GNU package for the organization HTTP tunnel with HeidiSQL. Read more...

'mysql.proc' doesn't exist fixed problem

_

Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...