Remote Database Connection
Enable Your Computer as an Access Host
By default, all IPs are blocked and must be added to an access list in order to access the server.
Therefore, before connecting to MySQL from another computer, the connecting computer must be enabled as an Access Host.
If you do not know your IP address, find it by going to www.ping.eu
Dynamic IP Addresses
Having a dynamic IP address means that the connecting IP address can change periodically, depending on the Internet Service Provider (ISP).
You must update the connecting IP in Remote MySQL every time it changes.
- Log into cPanel.
- Under Databases, click the Remote MySQL icon.
- In the Host field, type in the connecting IP address.
- Click Add Host.
You should now be able to connect remotely to your database.
Databse Configuration Settings
Use the following configuration settings for connecting to your database:
Host name = (use the server IP address)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (the password you entered for that database user)
MySQL Connection Port = 3306
TCP or UDP, either is fine.
Was this answer helpful?
This tutorial is going to teach you how to delete fields from database tables using phpMyAdmin....
The purpose of this tutorial is to teach you how to rename database tables with phpMyAdmin. We...
This tutorial is going to teach you how to copy a database table with phpMyAdmin. For the...
This tutorial is to teach you about specific operations in phpMyAdmin. We are going to learn how...
The purpose of this tutorial is to teach you how to modify fields in database tables with...