Accessing a remote database on cPanel

Procédure

How to connect to a remote database in cPanel

cPanel's Remote MySQL tool allows you to remotely connect to your database.
This feature allows remote hosts to access the MySQL databases in your account.

This tutorial shows you how to access your database remotely

How to connect to a remote database in cPanel

To authorise an ip address or domain to connect to your database, log in to your cPanel :

Then click on the Remote MySQL icon

The following form will be displayed:

In the Host text box you can specify remote hosts that can access your cPanel's MySQL databases.

• You must enter a full domain name (FQDN) for example: mon-domaine-lws.fr, an IPv4 address or an IPv6 address.

In the How text box, you can enter a description to identify the IP address. This step is optional and limited to 255 characters.

Then click on the Add a host button to save the changes.

Warning: Remote access to databases is tolerated on our hosting packages, but there are certain restrictions. Remote access to databases must be occasional. For example, using software such as mysql workbench, which allows you to connect to the database from time to time to perform operations on it, is not a problem. On the other hand, it will not be possible to have data from a site hosted by provider A and the database hosted on your hosting. Similarly, it will not be possible to have persistent or H24 access to a remote database.

Conclusion:

You have now learned how to remotely connect to your database in cPanel.
This is useful, for example, if you want to authorise shopping basket or guest book applications on other servers to access your databases.

Don't hesitate to share your comments and questions!