MySQL: How to access the MySQL database in OnApp?

Question

I need to access the OnApp database in MySQL on my CP server.

***Disclaimer***

Directly accessing the OnApp database on the server can result in serious errors in your cloud that may not be reversible. Before making any changes to the database records, it is strongly recommended that you backup your data by taking a mysqldump.

******************

Environment

OnApp Cloud (All Versions)

Answer

To access the OnApp database, log into your CP server and run the following command:

cat /onapp/interface/config/database.yml

In most installations the mysql server will reside on the CP server, the user will be root and the database name will be onapp. The above command will tell you the host, user, database and password. Once you have this information, you can log into the MySQL command prompt with the following:

mysql -u root -p

It will then prompt you to enter the password. Enter the password from the database.yml file, and you should get the mysql prompt:

mysql>

To select the onapp database for usage, run the following command:

mysql> use onapp;

This will set you up to access the onapp database through the MySQL command line.