Recent News
May 04, 2012
Next week upgrades and testing of the core network has been planned affecting services in our Auckland DC.Read More
Apr 18, 2012
It's a new year with lots of changes at Simplehost. Behind the scenes we have been upgrading our infrastructure to give faster performance, adding new customer experience features in our plans, and lowered our prices.Read More
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
- Login to your account https://secure.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.
