By defualt remote MySQL connection are disabled at many hosting provider’s end due to security reasons. If you don’t have the option in your cpanel ask your hosting provider to enable.
There are multiple programs available which are used to connect remotely to your DB. Dreamweaver is also used to connect your database remotely.
Remote MySQL Connection
In order to allowing remote connection from cPanel it is essential that you know your IP address that would accessing the DB. In order to know your ip you can go to site https://www.whatismyip.com/.
1. Login to your domain’s cPanel
2. Scroll down to the “Databases” section. Click on the icon “Remote MySQL”.
3. Enter your ip address and click the button Add Host.
Congratulation you now know how to allow remote access do the database in cPanel.