Simplehost Web Hosting

Connecting to MySQL

Details on connecting to the MySQL server remotely through a Web interface (phpMyAdmin), from the command line, or using a tunnel.

Using phpMyAdmin
  • From the Dashboard page click the 'Manage' link beside the database, login with your MySQL user and password.
Using PuTTY with SSH

Note:  If this is your first time connecting to Simplehost via SSH you may need to enable your SSH access.  Please submit a support request here to arrange it.

  • Start PuTTY

- Under "Host Name" enter: host.simplehost.co.nz

  • The host part of the domain name above will be the same host you use to connect to for FTP or SSH, this is the server your website is hosted on.  You can find the correct host by logging into your My Account and clicking the 'Server Settings' link.

- Tick the SSH radio button

- Under "Saved Sessions" enter a name to save this connection as, then click the "Save" button.

  • Click the "Open" button

On the command line enter the following command with your username without the comment (#).

# mysql -u <username> -p

Using an SSH tunnel

Note:  If this is your first time connecting to Simplehost via SSH you may need to enable your SSH access.  With recent security enhancements, simply tell us you need tunnel access too.  Please submit a support request here to arrange it.

Using the command line or an SSH client a tunnel can be configured to access MySQL using your favourite clent.

Mac OS X, Linux and UNIX

  • Fire up your terminal and create an SSH tunnel using the command below:

# ssh -L3307:127.0.0.1:3306 -p 22 -N user@host.simplehost.co.nz

  • Replace the italic parts of the command with your login details.  Enter your Simplehost account password.

Windows

You can setup a tunnel using PuTTY like this.

Once the tunnel is sucessfully created you can then connect to MySQL using the following hostname and port:

  • Host: localhost
  • Port: 3307

 

If you need any help don't hesitate to let us know.

support@simplehost.co.nz

 

Recent News
Feb 13, 2016

We have deployed PHP 7.0 to selected servers which has up to 4x performance gain on previous versions as well as the most comprehensive language API available. Read More


Feb 08, 2015

Bitcoin payments are now accepted for all hosting products. Bitcoin payments are simple, fast and simple to do on a mobile device. Get your digital wallet today and pay with Bitcoin. Read More