How to Connect to the MySQL Database Remotely.. cPanel
Please ensure that the local machine IP address has been enabled in cPanel >> mysql database >> Mysql Access Host
In order to connect the mysql database remotely need to following Configuration Settings:
Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (whatever you picked)
MySQL Connection Port = 3306
TCP/UDP anyone should be fine.
Note: port 3306 for your IP address to be able to connect to MySQL remotely.