|We moved this page to our Documentation Portal. You can find the latest updates here.|
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, 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:
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.