Win10/WSL2环境下MySQL Docker容器持续重启问题求助

环境信息 #

• 技术栈：Win10/WSL2/Ubuntu/Docker Desktop
• 触发场景：执行make setup启动容器后，Redis、php-fpm等容器正常运行，仅MySQL容器始终处于重启状态

Docker Compose中MySQL配置 #

mysql:
  hostname: a-mysql
  container_name: a-mysql
  image: mysql:8
  restart: unless-stopped
  volumes:
      - ./mysql_data:/var/lib/mysql
      - ./mysql/my.cnf:/etc/mysql/conf.d/my.cnf
      - ./mysql/dump:/docker-entrypoint-initdb.d
  env_file:
      - .env
  ports:
      - 7306:3306
  environment:
      TZ: "Asia/Jerusalem"
      MYSQL_ALLOW_EMPTY_PASSWORD: "no"
      MYSQL_ROOT_PASSWORD: ${MYSQL_INITDB_ROOT_PASSWORD}
      MYSQL_USER: ${MYSQL_INITDB_USER}
      MYSQL_PASSWORD: ${MYSQL_INITDB_USER_PASSWORD}
      MYSQL_DATABASE: ${MYSQL_INITDB}
  networks:
      - external-php-net
      - internal-php-net
  command: ["mysqld", "--mysql-native-password=ON"]
  #command: --default-authentication-plugin=mysql_native_password

Makefile相关配置 #

up: #create and start containers
    @docker compose up -d

down: #stop containers
    @docker compose down

rebuild: #rebuild all
    @docker compose down && docker compose up -d --build

connect_back: #connect to laravel application
    @docker exec -it ]php-fpm bash

database-import:
    @../e.back/database/snapshots/database_import.sh

setup:  ## Create and start containers
    $(MAKE) up-redis
    $(MAKE) up-mysql
    $(MAKE) install
    $(MAKE) up-frontend
    $(MAKE) up-php
    #$(MAKE) init
    $(MAKE) up-nginx

容器日志错误信息 #

• 无法打开mysql.plugin表，需执行MySQL升级
• 无法设置private_key.pem文件权限（操作不允许）
• SSL配置缺失证书和私钥
• 全局可写配置文件被忽略

已尝试的解决方法 #

• 使用chmod命令修改相关文件及目录权限
• 配置wsl.cnf调整WSL2权限参数

内容的提问来源于stack exchange，提问作者ANDREI MIRONOV