Includes free SSL certificate, unlimited bandwidth & fully optimised for WordPress.
Fully PCI-DSS compliant hosting, backups every 4 hours & free DDoS protection.
Unlimited bandwidth, WHM & cPanel control panel & fully white label.
Great value domain names available.
Create a professional looking website in minutes. Over 190 templates.
Speed up the delivery of your site.
Beautifully Simple. Massively Configurable. Scales from 1 VPS cloud, all the way up to a load balanced cluster.
Fully managed, high-spec dedicated servers deployed on our gigabit network, backed by our superior 24/7 UK support.
For our clients only. Open a ticket you can track and reply to.
Instantly talk to one of our support team, we're here to help.
Talk to us: 020 8050 1337 (Monday–Friday 9am – 8pm)
Business plans have access to 24/7 emergency phone support.
Search our extensive archive of guides to help you with your hosting account.
or go directly to our support site:
MySQL server runs on each local hosting server on TCP Port 3306 (the standard port for mysql). When your web scripts connect to MySQL they can do so using simply localhost as the server name. However, you can also connect to your databases from an external host, such as your home PC, office, or another web server.
PREPARING TO CONNECT
Before getting started you will need the IP address of the host you are connecting FROM, this can be done by browsing to http://viewmyip.co.uk on the device in question or asking the provider of the server your connecting from.
This guide assumes you have already successfully logged into cPanel.
Step 1 - Firewall access
Due to changes in how we handle remote MySQL connections, we no longer need to manually whitelist IP addresses in our firewall. This means the only consideration you need to apply at this stage is whether your IP address is static or dynamic.
If your IP address is not static, and changes on a regular basis, then you will need to keep in mind you will need to add each new IP address following on from Step 2, as such we recommend looking into an SSH tunnel so you can connect to MySQL via the SSH tunnel.
This is an advanced topic for most, although we are happy to offer advice, and there is a guide here which explains how to connect to MySQL using an SSH tunnel.
Step 2 - MySQL access
Click on the Remote MySQL icon in the DATABASES section of cPanel.
Enter your IP address in the Add Access Host field provided and click the Add Host button.That will grant access to MySQL for the host you provided.
BE AWARE THAT THIS METHOD OF CONNECTION IS NOT SECURE - Credentials are passed unencrypted, so are open to eavesdropping attacks. For greater security we recommend you connect using an SSH tunnel.