Calls to your database use the hostname localhost, a default hostname that refers to the common host running the application and the database.
Remote access could be required for such purposes as using data in applications on different hosts, updating data from different hosts, syncing data or manipultaing datya with remote database tools such as Navicat.
To allow access to a MySQL database by applications not running on "localhost" you need to specify the IP address of the system that requires access.
Go to the "Databases" section of your cPanel and click on Remote Database Access.
In the Remote Database Access control, enter the IP address of the host you wish to allow access. You can use the "%" wildcard character where the IP number may change. Use of any wildcard however increases the risk of unauthrised access so use with care.
When calling a remote database you need to specify a host name other than localhost. You can use the domain name (yourdomain.com) or the IP address of your domain. Ensure that port 3306 is open as this is the port used for MySQL communications. Don't confuse the server name (which is local in nature) with the hostname, which is global in nature by virtue of always being mapped to an IP address.
When remote access is no longer required, remember to remove the IP address from the allowed list.
