I am dockerizing my laravel application but I am getting this error
SQLSTATE[HY000] [1045] Access denied for user 'root'@'172.18.0.3' (using password: YES) (SQL: select * from information_schema.tables where table_schema = testdb and table_name = migrations and table_type = 'BASE TABLE')
docker-compose.yml
version: “3.8”
services:
# 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
database:
image: mysql:8.2
ports:
- 3306:3306
environment:
- MYSQL_DATABASE=${DB_DATABASE}
- MYSQL_USER=${DB_USERNAME}
- MYSQL_PASSWORD=${DB_PASSWORD}
- MYSQL_ROOT_PASSWORD=${DB_PASSWORD}
volumes:
- db-data:/var/lib/mysql
volumes:
db-data: ~
Dockerfile
FROM php:8.2 as php
RUN apt-get update -y
RUN apt-get install -y unzip libpq-dev libcurl4-gnutls-dev
RUN docker-php-ext-install pdo pdo_mysql bcmath
#RUN pecl install -o -f redis
# && rm -rf /tmp/pear
# && docker-php-ext-enable redis
WORKDIR /var/www
COPY . .
COPY --from=composer:2.7.4 /usr/bin/composer /usr/bin/composer
ENV PORT=8000
ENTRYPOINT [ "./docker/entrypoint.sh" ]
.env
APP_NAME=ArtisanOga
APP_ENV=local
APP_KEY=base64:3Xsn8ZJVdxfgfg1+e6CqdWWIX/SNGW49T7AL4N6C73E=
APP_DEBUG=true
APP_URL=http://localhost
LOG_CHANNEL=stack
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug
DB_CONNECTION=mysql
DB_HOST=database
DB_PORT=3306
DB_DATABASE=artisanoga
DB_USERNAME=root
DB_PASSWORD=secret