Connecting to MySQL
To connect to the MySQL server remotely on Simplehost you can do this through a Web interface (phpMyAdmin) or the command line using SSH.
Using phpMyAdmin
- Point your browser to: https://secure.simplehost.co.nz/login
- Login in to your 'My Account' page. 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, on the left hand list you want to navigate to SSH.
- Under remote command enter: "mysql -u <username> -p"
- <username> represents your username with simplehost, you will be prompted to enter your password you do not need to type it here.
- Make sure the "Prefered SSH Protocol version" is either 2 or 2 only
- Navigate on the left hand list back to "Session"
- 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
- You will be prompted for you username and password, you will be asked a second time for your password to get into MySQL.
Using an SSH tunnel
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.
Using a Unix command line or an SSH client a tunnel can be configured to access MySQL using your favourite clent.
- Create an SSH tunnel using a Unix 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.
Alternatively 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.