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