How to Connect to Your Database Remotely

MySQL allows a certain domain name or IP address to connect to a database remotely. You can do this by adding your domain name or IP address to access the host.

Before you connect to your MySQL database from your machine using a third-party application, you will need to add your network IP address to allow this. You can get your IP address via What Is My IP Address.

Once you have your domain name or IP address in hand, follow these steps to allow remote access:

Step 1. Log in to the cPanel using this link format: http://yourdomain.com/cpanel/ 
Replace yourdomain.com with the Main Domain Name connected to your hosting.
Step 2. Click Remote MySQL® under Databases panel.

remote access for mysql via cpanel vodien

Step 3. Type your IP address or domain name under Add Access Host field.

add access host for mysql database via cpanel vodien

Step 4. Click Add Host to save.

You’re now ready to remotely access your MySQL Database, most applications will ask for the details below:

  • Host Name – IP address of your hosting server
  • Database Name – Name of the database you’d like to connect
  • Database Username – Username you used for the database
  • Database Password – Password of the database you’d like to connect
  • MySQL Port – 3306

Please don’t hesitate to contact our 24/7 Singapore or Australia Support Team if you have further questions.

(Visited 140 times, 1 visits today)