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.
Step 3. Type your IP address or domain name under Add Access Host field.
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