Connecting 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

If you are using the Legacy Interface:

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

If you are using the New ACC Interface:

You can find this information by going to the Databases interface and clicking the Details button next to your database.

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