Solved Adding a second db to php 7.4 app

[Shai]

I have a couple of drupal/civicrm sites that I'm migrating to one of my Cloudrons. I will be using the php 7.4 app. The typical setup is for Drupal and CiviCRM to each have their own database.

This snippet below is from the Cloudron php 7.4 docs; I can infer that it is possible to create more than one database from the comment "only set when using a single database, see below." However, later in the documentation there are no references that I found to adding another database. In both phpMyAdmin and via the MySQL terminal it is not possible to create a second database.

It is possible to run Drupal and CiviCRM on the same database using table prefixes, but I'd prefer to have two databases for a bunch of reasons.

Is it possible to create another database? And if so, how do I do it?

CLOUDRON_MYSQL_URL=            # the mysql url (only set when using a single database, see below)
CLOUDRON_MYSQL_USERNAME=       # username
CLOUDRON_MYSQL_PASSWORD=       # password
CLOUDRON_MYSQL_HOST=           # server IP/hostname
CLOUDRON_MYSQL_PORT=           # server port
CLOUDRON_MYSQL_DATABASE=       # database name (only set when using a single database, see below)

[girish]

@shai you have to build a custom app, please see this guide https://docs.cloudron.io/guides/multiple-databases-lamp/