【MySQL】dockerのMySQLでクエリログを出すサンプル

docker-compose.yaml

  db:
    image: mysql:8
    container_name: db
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: password
      MYSQL_DATABASE: test
    ports:
      - "13306:3306"
    volumes:
      - ./data/db:/var/lib/mysql
      - ./data/db/log:/var/log/
      - ./my.cnf:/etc/mysql/conf.d/my.cnf

my.cnf

[mysqld]
log_output=FILE
general_log=1
general_log_file=/var/log/general.log