multiple databases

[ArmandArthur]

I have created the container database with root random password. (Where it is?)
And i have tried to create a database with command:

php bin/console doctrine:database:create --connection=customer

But it's use the user mysql, i can't create second database, same in worchbench.

Do i need to set password about root?

[7-zete-7]

Hi @ArmandArthur!

Usually, the root user password is written in the container logs during the first initialization of the database container.

Also, usually, databases, with their standard configuration, work only with one database for the configured user. For more flexible settings, they usually suggest using something like scripts or DDL/SQL queries mounted to the /docker-entrypoint-initdb.d directory of the database container.

More information about this can be found on the README page of the Docker image you are using.

Which Docker image are you using for the database service?

[ArmandArthur]

Hi,

I used
image: mysql:${MYSQL_VERSION:-8}

I don't know where is the /docker-entrypoint-initdb.d
After or before build?

[7-zete-7]

Thanks for the Docker image name, @ArmandArthur!

You can find information on how to customize this Docker image (via /docker-entrypoint-initdb.d) on the page of this Docker image (see the Initializing a fresh instance section on https://hub.docker.com/_/mysql). There is no need to rebuild Docker images.