The most secure and convenient way to access and manage your database is using a desktop app via SSH. Here are the apps we recommend:

macOS - Sequel Pro
Windows & Linux - DBeaver

With all of these apps, you enter your SSH connection credentials (the same credentials you use to SSH into your server) AND your database connection info:

Host: 127.0.0.1
Database: the name of the database you want to access
Username: the database user that has access to this database
Password: the database user password
Port: 3306

The app will connect to the server via SSH and then connect to the database.

Login