1. Home
  2. Databases
  3. How to Connect to Your Database with SSH

How to Connect to Your Database with SSH

You can use SSH to connect to a database that was created in the Account Control Center (ACC). By doing this, you will be able to make changes from the terminal/command line.

Connecting to Your Database with SSH

Note that when databases are created, an access level has to be selected. If you have a local only access level, you will not be able to make remote connections. Be sure that the access level allows the type of connection you are trying to make.

  1. Connect to your account using SSH. For instructions on connecting to your account with SSH, How to Connect to Your Account with SSH
  2. Once you have logged in to your account, type in the command:

    mysql -h dbDomain.pair.com -u dbUser -p dbName
    

    DBdomain.pair.com

    This is your database’s server.

    DBuser

    This is your database’s user.

    This user is not the same as your account username. Each database has three different users, each one with different access levels. For more information about the users and their access levels, see our article, How to Find Your Database Username.

    DBName

    This is your database’s name.
  3. Enter the database password

You can find this information by going to the Manage Your Databases interface and clicking the name of your database.location image

This will log you into your database. You can make changes from the command line here.

Updated on July 3, 2018

Was this article helpful?

Related Articles