Each Scalingo for MySQL® addon comes with a default database. You can, however, create multiple databases on the same Scalingo for MySQL® instance. In this case:

• The memory and disk storage allocated in the plan are shared between all databases
• By default, the database users (the default one and the ones you could have created) are shared between databases, even for existing ones
• All databases are backed up in the same backup file
• The platform doesn’t provide any environment variable for these additional databases. You should, however, be able to generate one from the original SCALINGO_MYSQL_URL.

Listing Existing Databases

Using the Database Dashboard

1. From your web browser, open your database dashboard
2. Click the Settings tab
3. In the Settings submenu, select Databases

Using the Command Line Tool

1. Access your database using the Interactive Remote Console
2. From the MySQL® console, run the following command:

   SHOW DATABASES;
   

   The ouput should look like this:

   mysql> SHOW DATABASES;
   +--------------------+
   | Database           |
   +--------------------+
   | my_app_5432        |
   | my_database01      |
   | my_database02      |
   | information_schema |
   | performance_schema |
   +--------------------+
   5 rows in set (0.01 sec)
   

Creating a New Database

Using the Database Dashboard

1. From your web browser, open your database dashboard
2. Click the Settings tab
3. In the Settings submenu, select Databases
4. Fill the Add a database form by specifying a name for the new database
5. Validate the form by clicking the Create this database button

Deleting a Database

Using the Database Dashboard

1. From your web browser, open your database dashboard
2. Click the Settings tab
3. In the Settings submenu, select Databases
4. Locate the database you want to remove
5. Click the “…“ button next to the database
6. From the popup menu, select Drop
7. In the popup window, confirm the deletion by typing the name of the database
8. Validate by clicking the Confirm button