Remote MySQL allows a certain domain name or IP address to connect to the database remotely by adding the domain name or IP to the access host.
Before connecting to MySQL from your machine using your third party application, you will need to add your network IP address to allow remote MySQL connection. Please follow the steps below.
Add Access Host for remote MySQL
Step 1. Log in to the cPanel.
Step 2. Click on Remote MySQL® under Databases panel.
Step 3. In the Remote MySQL® page, type in the domain name or IP address in the Add Access Host field.
Step 4. Click on Add Host button.
In your application, refer to these below details to connect:
Host Name = IP address of your server
Database Name = enter your database name
Database Username = your database username
Database password = your database password
MySQL Connection Port = 3306
Do not hesitate to contact our support team if you have further questions.