Hi, I’m able a create a new single database with Docker run command $ docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag Then I bash into the mysql container with exec and create another database in their at the mysql> prompt. Now how do I do that with the docker run co…

The official mysql image has some features in its entrypoint script to help you initialize your database. Check out https://hub.docker.com/_/mysql/ and scroll down to “Initializing a fresh instance”. Basically you can drop in some .sql or .sh scripts into a certain location that can import whatever …

@programmerq It is wrong suggestion about creating another one Database through /docker-entrypoint-initdb.d just because mouthed sql files will be imported by default to the database specified by the MYSQL_DATABASE variable. Since you can’t create DB in DB :slight_smile:

Created clear example of docker-compose with multiple databases, just use for your purposes: [image] abagayev/docker-bootstrap-collection docker-bootstrap-collection - Docker bootstrap templates to start new applications faster

Here is an example: https://gist.github.com/MKagesawa/a03892b8c44c015cd991c2c5311f1768 You can pass a shell script creating the dbs # The official MySQL (https://hub.docker.com/_/mysql/) supports only one MYSQL_DATABASE environment variable. # By modifying the entrypoint and passing shell script, …

Multiple Databases in Official MySql Container

General

abagayev (Anton Bagaiev) June 8, 2018, 10:11pm 4

Created clear example of docker-compose with multiple databases, just use for your purposes:

Topic		Replies	Views
Image MariaDB - Creation of several databases with new variable env MYSQL_DATABASES = "one two three" General dockerhub	0	11874	May 6, 2018
Database overwriting when creating mysql container General build , docker-compose , mysql	2	488	January 1, 2024
Automation of container creation and creating image with DB packed General	3	11196	December 14, 2015
Dcoker container doesn't create mysql schema on start-up Compose docker-compose , mysql	0	1799	April 26, 2023
How to use multiple databases in one docker container? General docker	0	4806	January 21, 2020

Multiple Databases in Official MySql Container

Related topics