How do I access my MySQL database?
Please note: This support article is a guide for our Linux users only.
The following article explains how to access your MySQL database when you are logged in to the webserver using SSH.
In order to access your MySQL database, please follow these steps:
- Log into your Linux web server via Secure Shell.
- Open the MySQL client program on the server in the /usr/bin directory.
- Type in the following syntax to access your database:
$ mysql -h {hostname} -u username -p {databasename}
Password: {your password}hostname: the name of the MySQL server that you are assigned to, for example, mysql4.safesecureweb.com
databasename: the name of your MySQL database
password: the password you use to access your MySQL database
Note: You can also download a graphical MySQL client that will allow you to access your database remotely from your desktop PC. The client can be found at the MySQL website.