Database name - Your cPanel username database name
Database username - Your cPanel username database username.
Database password - The database user password
Note: You can find your database credentials in your WordPress root folder(File manager-> public_html folder-> wp-config.php) and open the file
MySQL Connection Port - 3306
TCP or UDP, either is fine. How to set up a Remote Connection to my Database? By default, servers don’t allow remote access to their databases except to specific IP addresses. So we need to add our IP address to the whitelist. If your IP changes frequently, please use a hostname or update the connecting IP in Remote MySQL every time it changes. The connecting computer must be enabled as an Access Host before connecting to MySQL from another computer Perform the following steps to set up a remote connection to your database
- Log into cPanel
- Click the Remote MySQL icon under Databases.
- Fill in the IP address(You can find and add your IP address directly from this address whatismyip.com)
- Click Add Host, and you should get a confirmation message Access Host Added and you should now be able to connect remotely to your database.
Follow the steps below to remove a host from accessing databases on your server
- Log into cPanel
- Click the Remote MySQL icon under Databases.
- Click the X icon next to the IP address.
- Click Yes.