How to do a remote MySQL?

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.

cPanel-Login-SS

Step 2. Click on Remote MySQL® under Databases panel.

remote-mysql

Step 3. In the Remote MySQL® page, type in the domain name or IP address in the Add Access Host field.

add-access-host

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.

Remote MySQL

(Visited 83 times, 1 visits today)