Laravel 8和Docker Desktop - MySQL问题(MYSQL_PASSWORD不能用于根用户)

version: '3.8'

services:
  app:
    image: laravel:8
    container_name: laravel_app
    build:
      context: .
      dockerfile: Dockerfile
    ports:
      - "8000:8000"
    depends_on:
      - db
    volumes:
      - .:/var/www/html

  db:
    image: mysql:5.7
    container_name: mysql_db
    environment:
      MYSQL_ROOT_PASSWORD: root_password  # 设置 root 用户的密码
      MYSQL_DATABASE: laravel_db            # 创建的数据库
      MYSQL_USER: laravel_user               # 创建的用户
      MYSQL_PASSWORD: user_password          # 创建用户的密码
    ports:
      - "3306:3306"
    volumes:
      - db_data:/var/lib/mysql

volumes:
  db_data:

DB_CONNECTION=mysql
DB_HOST=db
DB_PORT=3306
DB_DATABASE=laravel_db
DB_USERNAME=laravel_user
DB_PASSWORD=user_password

# 停止并删除现有容器
docker-compose down

# 清理未使用的卷
docker volume prune

# 重新构建并启动容器
docker-compose up --build

docker exec -it mysql_db mysql -u root -p

SELECT User, Host FROM mysql.user;

docker logs mysql_db