Create database on docker-compose startup

Question

I would like to create a MySQL database using environment variables in docker-compose.yml file, but it is not working. I have the following code:

# The Database database:   image: mysql:5.7   volumes:     - dbdata:/var/lib/mysql   restart: always   environment:     MYSQL_ROOT_PASSWORD: secret     MYSQL_DATABASE: homestead     MYSQL_USER: root     MYSQL_PASSWORD: secret   ports:     - "33061:3306" 

Could someone explain the function of this vars?

Answer 1

There is also an option to provide an init file for mysql container which will be applied each time a container is created.

database:     image: mysql:5.7     ports:         - "33061:3306"     command: --init-file /data/application/init.sql     volumes:         - ./init.sql:/data/application/init.sql     environment:         MYSQL_ROOT_USER: root         MYSQL_ROOT_PASSWORD: secret         MYSQL_DATABASE: homestead         MYSQL_USER: root         MYSQL_PASSWORD: secret 

Such file (init.sql) could contain your initial database structure and data - for example:

CREATE DATABASE IF NOT EXISTS dev; CREATE DATABASE IF NOT EXISTS test; USE dev; CREATE TABLE IF NOT EXISTS (...);