Please follow the steps below to access MySQL database on a Linux Dedicated servers .

IMPORTANT : You should login into the web server using SSH to access the MySQL database.

Steps :-

1) Login to the Linux web server using Secure Shell.

2) Open the MySQL client program on the server in the /usr/bin directory.

3) Type in the following syntax in order to access your database:

$ mysql -h {hostname} -u username -p {databasename}
Password: {your password}

4) hostname: the name of the MySQL server that you are assigned to, for example,      mysql4.dedicatedserverhostingonline.com

5) databasename: the name of your MySQL database

6) password: the password you use to access your MySQL database.

[Post to Twitter] Tweet This

Leave a Reply