Remote connections to the MySQL databases on your Hosting Account must be made through an SSH Tunnel.

Note: If SSH is not enabled for your account (it is turned off by default), you will need to send us an email or call on 1300 694 678 to have it turned on.

The basic steps to connect are:

• Ensure you have the proper information to connect.
• SSH tunnelling software on the computer you wish to connect to the Web Hosting Account.
• Remote MySQL software to use your database (We will not cover this last step here).

Information needed:

• Your Domain Name (E.g. dpsupport.com.au)
• Your cPanel Username (E.g. dpsupport)
• Your cPanel Password (E.g. ghj543mnb)

Installing and configuring the Software

There are many programs available for creating an SSH tunnel. We will be using Bitvise Tunnelier v4.40 for this article.

To download and install Tunnelier go here: http://www.bitvise.com/tunnelier-download

Once you have downloaded and installed Tunnelier, you will need to configure it.


How to configure Tunnelier:

1. 1. Under the Login tab, enter in the following information --
      • Server Host: Your Domain Name
      • Port: 22
      • Username: The cPanel username for your account
      • Change the Initial Method to "password"
      • Tick the box for Store encrypted password in profile
      • Password: The cPanel password for that account

1. Under the Options tab untick Open Terminal and Open SFTP

1. Under the C2S tab, enter in the following information --

• Listen Interface: 127.0.0.1
• List. Port: 3306
• Destination Host: Your Domain Name
• Dest. Port: 3306
• Comment: MySQL