mysql-wordpress-redmine

docker-compose.yml

version: '3'

services:
  db:
    image: mysql:5.7
    volumes:
      - ./docker-entrypoint-initdb.d:/docker-entrypoint-initdb.d
      - ./docker-db:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: mysql-root-container

  wordpress:
    depends_on:
      - db
    image: wordpress:latest
    ports:
      - 8001:80
    environment:
      WORDPRESS_DB_HOST: db
      WORDPRESS_DB_USER: wordpress
      WORDPRESS_DB_PASSWORD: wordpress-container-test

  redmine:
    depends_on:
      - db
    image: redmine
    ports:
      - 8002:3000
    environment:
      REDMINE_DB_MYSQL: db
      REDMINE_DB_DATABASE: redmine
      REDMINE_DB_USERNAME: redmine
      REDMINE_DB_PASSWORD: redmine-container-test

init.sql

CREATE DATABASE IF NOT EXISTS wordpress;
GRANT ALL ON wordpress.* TO 'wordpress'@'%' IDENTIFIED BY 'wordpress-container-test';

CREATE DATABASE IF NOT EXISTS redmine;
GRANT ALL ON redmine.* TO 'redmine'@'%' IDENTIFIED BY 'redmine-container-test';