How to access MySQL remotely

Knowledgebase Article

How to access MySQL remotely

In order to provide full PCI compliance and improved security, we don't allow external MySQL connections.

So in order to access MySQL remotely, you will need to create an SSH tunnel with the MySQL client which you are using or in case the MySQL client doesn't have the feauture built in, you may need to use PuTTY with port forwarding to do the same thing.

Port forwarding with PuTTY.

Step 1: Start PuTTY.

In the Category pane, expand Connection, expand SSH, and then click Tunnels:

Step 2: In the Source port text box of the Port Forwarding section, type 3306.

This is the local port to forward. In the Destination text box, type localhost:3306:

Confirm that the Local and Auto radio buttons are selected.

Click Add.

Step 3:

In the Category pane, click Session.

In the Host Name (or IP address) text box, type your web site's domain name or IP address.

In the Port text box, enter the SSH port.

Confirm that the Connection type radio button is set to SSH:

Click Open.

If a PuTTY security alert about the server's host key appears, click Yes:

When the login as prompt appears, type your account username (i.e test), and then type your cPanel password:

When the remote server's command line prompt appears, the SSH tunnel is established and you can use your MySQL client applications on the local computer.

If SSH is not yet enabled for your account, please contact us via chat or support ticket so we could action this for you.