Docker環境のmysql初期立ち上げ時に、実行するSQLの設定

version: '3'

services:
  # MySQL
  db:
    image: mysql:5.7
    container_name: mysql_base
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: test_database
      MYSQL_USER: docker
      MYSQL_PASSWORD: docker
      TZ: 'Asia/Tokyo'
    volumes:
    - ./data:/var/lib/mysql
    - ./log:/var/log
    - ./conf/my.cnf:/etc/mysql/conf.d/my.cnf
    - ./init_dir:/docker-entrypoint-initdb.d
    ports:
    - 3306:3306
    networks:
      - external.group
networks:
  external.group:
    external: true

CREATE DATABASE IF NOT EXISTS `mysql_base`;
grant all privileges on `test_`test_database`.* to 'docker'@'%';
DROP DATABASE IF EXISTS `mysql_base`;