Tsohost Knowledge Base

How do I remotely access my database?

Modified Monday 14th April, 2014 at 01:14

Was this helpful?

Sometimes you may want to a access a database remotely, for example from your home computer (using software such as Navicat) or from another website. While we do not officially support using our systems as a database platform (it is there to host websites), you can allow a remote host to connect to your database.

Step 1: Login & Navigate to Databases

Log in to your cPanel account and click on the Remote MySQL icon under the Databases tab.

 

Step 2: Remote Database Access Hosts

Enter the IP address or domain into the Host text box and click Add Host. Note: If you are connecting from your PC, this should be your local IP address

 

Step 3: Access Hosts

You will now be able to see the IP address in the Access Hosts table.

Please note that we do not allow wildcard hosts access. It is a security vulnerability and we do not allow it. You need to enter in the full IP address

 

Step 4: Access Hosts Table

There is an option in the Access Hosts table to remove the IP address/domain from remotely accessing the database. To remove the IP address/domain just click on the X icon.

 

 

Step 6: Remove Access Host

To completely remove the IP address/domain click on the Remove Access Host button.

 

In order to connect remotely, you can use your domain name, or the server IP address. The port would be 3306 (the default)

You need to authenticate with the username and password shown under the MySQL Databases page. 


mysqldbremotecpanel

Still can't find what you're looking for?

Not a problem - our 24/7 customer support team are super friendly and here to help answer all your questions. There's no need to wait, click below to start a Live Chat.

Start Live Chat

Still can't find what you're looking for?

Not a problem - our 24/7 customer support team are super friendly and here to help answer all your questions. Don't delay, click below to find out how you can get in touch.

Get in Touch