This topic describes several different ways you can access and administer your Cloud Platform application’s Drupal database. For most of these tools, you will need the connection details and credentials for the database. See Viewing database information for information about where to find these.
Desktop applications
You can access and administer your application’s Drupal database using a desktop application that supports SSH tunneling. It specifies that you are connecting to the database through an SSH connection, using the same private key authentication that you use to SSH to the infrastructure. Here are some options to consider:
- MySQL Workbench: MySQL Workbench is a free, cross-platform, visual database design tool developed by MySQL. It runs on Windows, macOS, and Linux.
- Cloud Next: MySQL Workbench is not fully compatible with Cloud Next. As a temporary workaround, subscribers who want to resolve software connection issues with Cloud Next environments can:
- Locate the database credentials:
To locate your database credentials:- Sign in to the Cloud Platform user interface.
- Access an environment for your application.
- Click Databases.
- Click a database.
- Click Settings.
- Locate the SSH URL connection string.
To locate your SSH URL:- Sign in to the Cloud Platform user interface.
- Access an environment for your application.
In a local terminal, run:
ssh -L $LOCAL_PORT:$DB_HOST:3306 $SSH_URL
Here,
LOCAL_PORT
is the port to which Workbench must connect when using localhost.DB_HOST
is the database hostname obtained from the preceding stepsSSH_URL
is the full SSH connection string from the preceding step. For example,[email protected]
.
- Locate the database credentials:
- Cloud Next: MySQL Workbench is not fully compatible with Cloud Next. As a temporary workaround, subscribers who want to resolve software connection issues with Cloud Next environments can:
- Navicat for MySQL: A well-designed and popular commercial tool that runs on Windows, macOS, and Linux. This software isn’t tested to verify compatibility with Cloud Next environments.
phpMyAdmin
Acquia does not recommend you to use phpMyAdmin on Cloud Platform. This software can expose your application to unnecessary risk, especially if the software is not up-to-date. phpMyAdmin is not officially supported on Cloud Next, and subscribers can leverage alternative solutions.
Command line
You can also access your database over SSH and use MySQL’s command line. For more information, see Accessing your database from the command line.