By default, remote access to MySQL database server is disabled for security reasons. However, some time you need to do remote connection to your database server from home, from web server or standalone clients.
With HTTP Tunneling, you will be able to connect to your remote MySQL Server easily when your hosting company does not allow remote connection and does not provide SSH 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. This can be used when your ISPs do not allow direct connections to their MySQL server, but allows by establishing HTTP connections.
Using Navicat with HTTP Tunneling
With HTTP tunneling, you can establish a connection with your remote MySQL database server, and enjoy a set of useful features from Navicat which a web-based administration application cannot provide, including:
- Ability to import data from various file types including Access, Excel, CSV, Txt, HTML, XML, Paradox, QuattroPro and data from ODBC Source, directly to your MySQL database without a touch of SQL query.
- Building a query visually with the help of Query Builder.
- Making use of the data in your database to generate Reports.
- Synchronizing the data or schema between servers.
- Scheduling of database operational tasks.
Establishing a HTTP Connection to your Remote MySQL Server with Navicat To use this connection method, first thing you need to do is to upload the tunneling script – ntunnel_mysql.php to the webserver where your MySQL Server is located.To upload the script to your webserver, you will need a FTP client.Uploading the Tunneling ScriptStartup WS_FTP and configure the Session Profile Information.
This is the name of the FTP session profile, and can be anything you desire to identify the connection you are creating.Host name/Address:
The hostname for your webserver.
If you know the host type, select it from the drop down list. Otherwise, try Automatic detect.
Username of your webserver.Password:
Password of your webserver.
Select the Startup tab and enter Initial Directories for both Local and Remote system.
To upload the tunneling script:
1) Browse the ntunnel_mysql.php on the source system.2) Open the directory to which you want to transfer files on the destination system.
Transfer the files using the left and right arrow buttons located between the list boxes, i.e. Click the right arrow button to transfer files from the local to the remote system.
GoDaddy Control Panel In your GoDaddy Control Panel, Select Database > MySQL , you will then see the Database hostname in this page. This address will be the hostname you will need to place in the Connection Setting inside Navicat.
NavicatIn Navicat, Click the Connection button to new a connection.In the General Tab of the Connection Setting box:
Connection Name: A which best describe your connection.
Host name/IP address: A host where your MySQL Server is located.
Port: The port of MySQL Server on Remote Host, by default, it is 3306.
User name: MySQL Server user name.
Password: Password of the MySQL user.
In the HTTP Tab in the Connection Setting box:
1) Enable Use HTTP Tunnel.
2) Enter URL of the tunneling script.
If the ntunnel_mysql.php is hosted in a password protected server or you have to access internet over a proxy server, you will need to provide the required authentication details.To test if the Connection settings are correct, you may click the “Test Connection” button to check.Connecting to your MySQL Database from remote client Navicat offers you a greater flexibility on working with your data in MySQL. With Navicat, you can easily import your data in to your MySQL database from various file formats, build queries visually, set a schedule to perform backup, generate report from your raw data and more.For more information on how Navicat helps you to manage your MySQL database effectively, please visit here: http://mysql.navicat.com/details.html