Before you can connect to an SSH Tunnel you need to have SSH enabled on your account. If you’re unsure, log in to https://control.crucial.com.au/clientarea.php and submit a support request for SSH access to be enabled on for the specific cPanel account.
Also make sure you have your cPanel login details as these will be used to SSH into your server.
Depending on your MySQL client, this may be available from the configuration options for the software. Once such program for Mac is Sequel Pro.
If your MySQL client does not provide this functionality you can establish the SSH tunnel manually using the steps below.
1. First we need to open the Terminal. Click on Go > Utilities
Then, find and click on the Terminal App
2. In the Terminal, run the following command:
ssh cpanelusername@hostip -Llocalport:127.0.0.1:3306
Cpanelusername your cpanel account username
hostip the IP address off your server
localport a random port number (1211 is safe as it’s not a standard port)
Now that you’re connected via SSH, open a new terminal using command + t then run the following command:
Telnet 127.0.0.1 localport
That’s it! You’ve now got an SSH tunnel into MySQL.
If you are using Windows, please refer to our separate guide which is available here. here.