Navicat supports HTTP connection while your internet service providers do not allow direct connections to their server, but allows the establishment of HTTP connections. In this tutorial, we will employ gFTP to upload the php script file and establish a HTTP connection to a MySQL server in Navicat. First, startup gFTP, then enter the FTP server information and connect to the server. The php script file is available in the Navicat installation folder. Select the ntunnel_mysql.php on the local system and click the right arrow to transfer it to the remote system. Then, check to see whether or not the file was uploaded successfully. After uploading the script file, the next step is setting up the HTTP Tunnel in Navicat. Click the ‘Connection’ icon to start a new connection. In the Connection General tab, enter the server connection information; such as host IP address, port, username and password. Select the HTTP tab and enable the ‘Use HTTP Tunnel’ option, then enter the URL of the tunneling script. If the 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. Finally, click ‘Test Connection’ to check the connection and click ‘OK’ to save the connection settings.
