How to enable remote connection to a MySQL database on phpMyAdmin?
Remote Database Connection Setup
Note: If connecting from your home computer, you need a MySQL client like phpMyAdmin, Workbench or Dreamweaver.
What program do I use to connect Remotely?
There are a few programs you can use to connect remotely to your database. HTML editors like DreamWeaver can connect to your databases remotely as well. There are Free Open Source programs you can use like MySQL Workbench or or Heidi SQL.
Below are some links to programs you can use to connect to your databases remotely in a VPS Hosting.
Refer below steps to enable remote connection to a MySQL database on phpMyAdmin
1) Login ACP
2) Access phpMyAdmin
3) Go to User Accounts
4) Select the Username and click on Edit Privileges
5) Click on Login Information
6) On Hostname Select “Any Host” and click Go