What Is HTTP Tunnel?

HTTP Tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does. It is used while your ISPs do not allow direct connections to their MySQL server, but allows establishing HTTP connections.

Note: HTTP Tunnel and SSH Tunnel cannot function simultaneously. The SSH Tunnel is disabled when you select the HTTP Tunnel and vice versa.

Setting up HTTP Tunnel

To use this connection method, first thing you need to do is to upload the tunneling script - ntunnel_mysql.php to the webserver.

Note: ntunnel_mysql.php is available in the installation package.

The following instruction guides you through the process of configuring a HTTP connection.

1. Click or choose Connection > New Connection to set up the Connection Properties.
2. Select the HTTP tab and enable Use HTTP Tunnel.
3. Enter URL of the tunneling script.
   
   

   

4. If the ntunnel_mysql.php is hosted in a password protected server, you can provide the required authentication details.
   
   

   

5. Navicat MySQL host name at the General Settings page should be set relatively to the HTTP server in this case. For example: host_of_mysqldatabase shown below is the host address, which provided by your hosting company, of your remote MySQL database.
   
   Connection Name
   A friendly name to best describe your connection.
   
   Host name/IP address
   A host where MySQL Server is located in point of view HTTP server.
   
   Port
   A port of MySQL Server on Remote Host, by default it is 3306.
   
   User name
   It is a MySQL Server user name.
   
   Password
   It is a password of the MySQL user.