MySql Remote Database Connections

You can grant access to a MySQL database from an external location by adding a domain name or an IP address to a list of acceptable hosts list to allow access to the database remotely. Furthermore, if you use an application to manage your database, you would need to add the IP address that the connection is made from as an allowed access host. * * * The first step is to log into your cPanel account. If you are unsure on how to do this, please view the following help article - '[How to log into cPanel](https://hostpresto.com/help/article/1)'. ![alt text](https://i.imgur.com/QRmld56.png "Remote database connections 1") * * * Scroll down to the '**Databases**' section and choose '**Remote MySQL**'. ![alt text](https://i.imgur.com/MTf3jYU.png "Remote database connections 2") * * * Enter the domain name or the IP address where the remote database access connection will be established from - _you can use % as a wildcard for an IP range if need be_. ![alt text](https://i.imgur.com/YqMQioR.png "Remote database connections 3") * * * Select '**Add Host**' to allow the access. ![alt text](https://i.imgur.com/VV06YY8.png "Remote database connections 4") *** You should now see visual confirmation that the new host has been added. To review, select the '**Go Back** option. ![alt text](https://i.imgur.com/A1yOA9C.png "Remote database connections 5") *** You can now see under the '**Access Hosts**' list that the new host is present. ![alt text](https://i.imgur.com/zKXIcli.png "Remote database connections 6") If more remote database connections are required, you can repeat the process again by entering another host. Creating a MySQL remote database connection is now complete. * * *
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to log into cPanel

There are two different methods to log into your cPanel control panel in order to manage every...

What's the difference between Aliases, Addon and Subdomains?

### Aliases An Alias domain does not have a unique website. It is a domain that is masked to...

Creating a MySql Database

If your website uses PHP or you need to hold a collection of records which need to be accessed...

Importing a MySql Database

You can import a MySQL database via phpMyAdmin which is available in the cPanel control panel....

Exporting a MySql Database

You can export a MySQL database via phpMyAdmin, available in cPanel, if you want to keep a backup...