Remotely Access MySQL Database
The following article explains how to access your MySQL database remotely.
1)Go to Cpanel >> MySQL® Databases >> Access Hosts: >> Add IP of the machine from which you want to access databse.
2)Click on Add host.
In order to access your MySQL database, please follow these steps:
1. Log into your machine from which you want to access database remotely.
2. Open the MySQL client program on the server in the /usr/bin directory.
cd /usr/bin
Give the command
# mysql
3.Type in the following syntax to access your database:
$ mysql -h {hostname} -u username -p {databasename}
Password: {your password}
mysql >
* hostname: the name of the MySQL server that you are assigned to, for example, domainname/servername
* databasename: The name of your MySQL database
* password: The password you use to access your MySQL database
