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/<
If you have any questions regarding this process, please contact Support.