The easiest method is to install phpMyAdmin along side your application (on the same server).. and then log in to phpMyAdmin using the system username and password of the application you wish to connect to.
In other words, if I want to access the database of my Wordpress deployment using phpMyAdmin... I'd log in to phpMyAdmin with the system username and password provided for my Wordpress deployment.
You may also access your database directly from the command line.
But what if you want to access your database from an external database management tool like SequelPro or the MySQL Workbench?
As long as the management tool provides TCP/IP over SSH access... you should have no trouble accessing your database remotely.
Here are instructions for accessing your database using SequelPro.
- Choose the SSH type of connection
- Enter the relavent information in all of the required fields
- Press the Connect button
Once you have entered all of the required information and connected to your database, you'll be able to query, edit, add, and remove data directly from the database.
If you have any questions or trouble regarding this, please contact support.