how to allow remote database connect in cpanel

To allow remote database connections in cPanel, you can follow the steps below:

1. Log in to your cPanel account.
2. In the “Databases” section, click on “Remote MySQL” icon.
3. Enter the IP address of the remote server that you want to grant access to your database. You can use the “%” symbol to grant access to all IP addresses.
4. Click on the “Add Host” button to save the changes.

Once you have added the remote server’s IP address, you will need to configure your remote server to connect to your database. You will need to use the hostname provided by your cPanel account, along with the database name, database username, and database password to connect to your database remotely.

It is important to note that allowing remote database connections can pose a security risk. Therefore, you should only grant access to trusted IP addresses and use strong passwords for your database users.

Read –>>> How to create remote database connection using PHP