I have the following docker-compose.yml
version: '3.9' services: web: build: . container_name: web volumes: - .:/var/www/html ports: - 8000:80 networks: - db_bridge db: image: mysql container_name: db restart: always environment: MYSQL_ROOT_PASSWORD: ${DATABASE_ROOT_PASSWORD} MYSQL_DATABASE: ${DATABASE_NAME} MYSQL_USER: ${DATABASE_USER} MYSQL_PASSWORD: ${DATABASE_PASSWORD} ports: - 3306:3306 networks: - db_bridge networks: db_bridge: driver: bridge .env file looks as following:
###> Mysql ### DATABASE_ROOT_PASSWORD=root DATABASE_NAME=everphone DATABASE_USER=demo DATABASE_PASSWORD=password ###< Mysql ### DATABASE_URL="mysql://demo:password@db:3306/everphone?serverVersion=8.0" ###< doctrine/doctrine-bundle ### However when i try to run:
bin/console make:migration I get the following error:
An exception occurred in driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client Can you please tell me what is the problem here?