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?