docker-compose mysql

docker-compose.yml

version: "3.7"

services:
  mysql:
    container_name: apollo-work-mysql
    image: mysql:5.7
    restart: always
    ports:
      - 3306:3306
    volumes:
      - ./docker/mysql/conf:/etc/mysql/conf.d
      - ./docker/mysql/ddl:/docker-entrypoint-initdb.d
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_USER: test
      MYSQL_PASSWORD: test
      MYSQL_DATABASE: test_db
      TZ: 'Asia/Tokyo'

docker_myqsl_conf_conf.d

[mysqld]
character-set-server = utf8mb4
general_log = 1
general_log_file = /var/log/mysql/query.log
log-error = /var/log/mysql/error.log
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 0.1
log_queries_not_using_indexes = 1

[mysql]
default-character-set = utf8mb4

docker_myqsl_ddl_00-sample.sql

-- CREATE DATABASE test_db CHARACTER SET utf8;

CREATE TABLE test_db.tasks (
  id VARCHAR(36),
  overview VARCHAR(256),
  priority INT,
  deadline TIMESTAMP,
  PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


insert into tasks (id, overview, priority, deadline) values ('6a414c88-4613-486d-9990-80c1de52eea4', 'Learn TypeScript', 1, now());
insert into tasks (id, overview, priority, deadline) values ('d8a4132e-72ec-490c-b5f5-a8bbc4509be6', 'Learn Node.js', 2, now());