Details on connecting to the MySQL server remotely through a Web interface (phpMyAdmin), from the command line, or using a tunnel.
Using phpMyAdmin
- Login to your account https://simplehost.co.nz/login
- 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.
- You can download PuTTY from: http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe
- 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.