I am trying to dockerize laravel application but I am getting this error
SQLSTATE[HY000] [1045] Access denied for user ‘user’@’172.18.0.3’
docker-compose.yml
version: "3.8"
services:
# Database Server
database:
image: mysql:8.4.0
ports:
- 3306:3306
environment:
- MYSQL_DATABASE="${DB_DATABASE}"
- MYSQL_USER="${DB_USERNAME}"
- MYSQL_PASSWORD=password
volumes:
- db-data:/var/lib/mysql
# PHP Service
php:
build:
context: .
target: php
args:
- APP_ENV="${APP_ENV}"
environment:
- APP_ENV="${APP_ENV}"
- CONTAINER_ROLE=app
working_dir: /var/www
volumes:
- ./:/var/www
ports:
- 8000:8000
depends_on:
- database
phpmyadmin:
image: phpmyadmin
restart: always
ports:
- 8080:80
environment:
- PMA_ARBITRARY=1
volumes:
db-data: ~
.env
DB_CONNECTION=mysql
DB_HOST=database
DB_PORT=3306
DB_DATABASE=my_database
DB_USERNAME=user
DB_PASSWORD=password
I tried using
username: user
password: password
in phpmyadmin but it show access denied error