Standing Cloud Knowledge Base

Creating additional databases

Last Updated: Feb 08, 2013 05:09PM MST

By default, most deployments come with a single database associated with your application.

However, you may create additional databases by using the Supervisor account to retrieve the root password of MySQL and then create the additional databases, tables, and users for MySQL. 

Follow these steps.

1.  SSH to your server using the Supervisor account or by using the Admin Terminal feature found in the "Server Actions Menu".

2.  Display (cat) the password by typing:

sudo cat /usr/local/lib/sc/util/generatedRootDatabasePassword.txt

3.  Using that password, open mySQL as root by typing the following:

sudo mysql --user='root' --password='e93e1d14566dc8d8e93b'

4.  Create the new database from the mySQL command line. (i.e. create database TestDB)

5.  Setup a user, password, and privileges for access to the database.

6.  Use the newly created database.

Now you may use the database from either the command line or by accessing it via phpMyAdmin hosted on the same server.

Lastly, you need to tell the system to do a full MySQL backup by editing the "applicationstate" file found at ( /home/<<systemusername>>/.config/system/applicationstate ) by typing the following:

sudo vi  /home/<>/.config/system/applicationstate
NOTE: You will be prompted to enter the Supervisor password.


If you have any questions regarding this process, please contact Support.

comments powered by Disqus

Cloud application marketplace and management platform

    Email Us
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found