How do I enable SSH tunneling for MySQL on Mac?

To make it easier to get in touch with us, from the 24th of March 2016 all support tickets will need to be submitted from your Crucial Control Panel.

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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk