I need to access the OnApp database in MySQL on my CP server.
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.
OnApp Cloud (All Versions)
To access the OnApp database log into your CP server and run the following command
In most installations the mysql server will reside on the CP server and 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 for the password. Enter the password from the database.yml file and you should get the mysql prompt
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.