If you have external contributors to your website or your database resides on a different server, it makes sense to use remote database connections from your cPanel. Here’s how you can go about it:

Setting Up Remote Database Connections

Obtain the IP Address: First, get the IP address of the server from which you intend to establish the remote connection. You can use What Is My IP Address to find this information.

Access Remote MySQL in cPanel: Log into your account on cPanel, look for the Databases section, and then select Remote MySQL.

Add the Host: Clicking on it will bring you to a new page with a Host field where you can enter the IP address (or hostname) you identified earlier. After entering the IP address, select Add Host. If you want to grant database access to all IP addresses starting with 167.45.0, you can use the % character by entering 167.45.0.%.

Configure Remote MySQL Software: Popular software for configuring your remote MySQL connections include MySQL Workbench and Navicat. For this purpose, you’ll need your hostname, the name of your database, the database credentials, and port number 3306. If needed, ensure that the connection method is set to TCP/IP.

Removing Remote Database Access

If you’d like to remove database access that is no longer needed, simply navigate back to the Remote MySQL feature. Find the host in question, then click Delete next to its name and confirm the action by clicking the Remove Access Host button.