ACCESS MYSQL DATABASE

www.

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:

  1. Log into your Linux web server via Secure Shell.
  2. Open the MySQL client program on the server in the /usr/bin directory.
  3. 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.

Comments are closed.