How do I allow remote access to my MySQL database?

To allow remote access to your database, you will need to do this via the cPanel control panel.

For steps on how to download your database, please see the following:

 

  1. Log in to your LetsHost client area and click on Services > My Services
  2. You will see your products/services listed out here. Click on Active beside your hosting package
  3. On the menu on the left, click on Login to cPanel
  4. Once logged in to your cPanel control panel, click on the icon for Remote MySQL under the Databases section
  5. Fill in the IP address of the location you wish to access from, or use % to allow remote access from anywhere (we would recommend only using this temporarily). You can access your own IP address from https://ip.letshost.ie
  6. Click Add Host
  7. The final step is for this IP address to be whitelisted on the servers firewall – only LetsHost staff can do this for you
  8. You will need to open a ticket with our Support Dept. requesting for the IP address to be whitelisted to allow for remote database access

 

If you have any questions on the above, please do not hesitate to 'Open a Ticket' and we will be happy to advise further.

 

 

  • #database, #remote, #access, #mysql
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I create a database user and add it to a database?

Some types of websites (for example WordPress) work with a database to store you content and...

How do I create a database?

Databases are used to store data for your website or content management system (such as...

How do I backup MySQL databases in cPanel?

To download a backup of your database, you will need to do this via the cPanel control panel....

How can I import my MySQL database to my hosting account?

To import an SQL file into a MySQL database, please see the following steps. Please note that...

How do I export my database from cPanel

If you wish to export your database from your cPanel hosting account (for the purposes of backups...