11/6/2017 - It is no longer recommended to use this script, now that Navicat ships an updated ntunnel_mysql.php script with Navicat for MySQL 12+. To get the newer script, follow these instructions.
This is an updated tunnel script for connecting to MySQL and MariaDB databases with Navicat for MySQL via mysqli. The ntunnel_mysql.php script that comes with current versions of Navicat (as of 10/18/2016) will not work with PHP7, as procedural mysql functions have been deprecated.
HTTP Tunneling is a method for connecting to a 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, but allows establishing HTTP connections.
To set up an HTTP tunnel, first upload the ntunnel_mysqli.php script to your web server.
The following instruction guides you through the process of configuring a HTTP connection.
- Select the HTTP tab and enable Use HTTP Tunnel.
- Enter URL of the tunneling script, e.g. http://www.navicat.com/ntunnel_mysqli.php .
- If your server installed a Web Application Firewall, you can check the Encode outgoing query with base64 option.
- If the tunneling script is hosted in a password protected server or you have to access internet over a proxy server, you can provide the required authentication details in Authentication or Proxy tab.
- Navicat host name at the General settings page should be set relatively to the HTTP server which provided by your database hosting company.