Connect to a database via SSH

Connecting from a shell account

  1. Log into your MySQL database using your database credentials. View the Finding your database credentials article for instructions. You can also find these in the panel under MySQL Databases.
  2. Open your terminal application. You can do this on a Mac or Linux computer using the native terminal, or you could just log into your DreamHost web server instead of via SSH. If you're on Windows, use PuTTY to connect to your DreamHost server.
  3. Run the following command. Ensure you use your actual credentials for the following variables:
    • hostname - Your mysql hostname URL. It will appear like mysql.example.com.
    • user - Your database username
    • password - Your database username's password
    • database - Your database name
    [server]$ mysql -h hostname -u user -p database

You are then prompted for your password to log in. Once logged in, your command prompt will change to the following:

mysql>

You cannot use "localhost" to connect to your database, as DreamHost's MySQL servers are separate from the regular website servers.

MariaDB MySQL client used on a VPS

If you have a VPS, MariaDB is used as the MySQL client when connecting. All MySQL commands continue to function the same; the only difference is the text that appears when you originally connect to the database server. For example:

[server]$ mysql -h hostname -u username -ppassword database
        
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22774
Server version: 8.0.34-0ubuntu0.22.04.1 (Ubuntu) Copyright (c) 2000, 2022, Oracle and/or its affiliates Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL>

See also

Did this article answer your questions?

Article last updated PST.

Still not finding what you're looking for?