For database management, you can either use a WordPress plugin like ARI Adminer from within your site or one of the methods provided by VersionPress.com:
Adminer can be accessed from the Database tab on the site detail screen:
Most of the values will be pre-filled for you, you just need to copy the password (which we tried to make pleasant; try clicking the password field!).
Database access via SSH tunnel
You can access your database from a local tool like MySQL Workbench, HeidiSQL or
mysql client if you open an SSH tunnel. Some GUI tools will even automate this for you, see how to connect from PhpStorm as an example.
This method works for all local tools as it makes the database appear to be running locally – after the tunnel is open, the tools just connect to
To open the tunnel, click the Connect remotely button in the portal and follow the instructions:
Some tools can work over SSH tunnels directly. Our example will be PhpStorm but other tools work similarly, see e.g. HeidiSQL.
In PhpStorm, first make sure you have Database Tools and SQL plugin enabled. Then in the Database panel, click '+' to create a new connection. On the SSH/SSL tab, enter the SSH connection details:
The General tab should look like this:
The actual Host value will be something like
126.96.36.199, the screenshots are not updated yet. Note, however, that in PhpStorm, the value is not
If you also check the database on the Schemas tab, you can connect and browse the database:
For smaller database dumps of up to about 50 MB, you can use Adminer to import it conveniently.
For larger databases: