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 FileZilla to upload the php script file and establish a connection to a MySQL server using HTTP tunnel in Navicat. First, startup FileZilla, then enter the FTP server information and connect to the server. The php script file is available in the Navicat installation folder. Right-click the ntunnel_mysql.php on the local system and choose Upload. 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.
