Невозможно подключить Laravel к MySQL в Docker - база данных не найдена ошибки ⇐ Php

[Anonymous]

Я настраиваю проект Laravel с Docker и Docker Compose, но я сталкиваюсь с проблемами с моей базой данных. Misacom/
[*] dockerfile inside misacom/
[*]shrong>.env files для Laravel и Docker

h3>docker-compose.yml
h3>docker-compose.yml
. class = "Lang-Yaml PrettyPrint-Override">services:
app:
build:
context: ./misacom
dockerfile: Dockerfile
restart: unless-stopped
ports:
- "9000:9000"
- "8000:8000"
depends_on:
- mysql
networks:
- internal_network
volumes:
- ./misacom:/var/www/html
- ./misacom/storage:/var/www/html/storage

mysql:
image: mysql:9.2.0
ports:
- "3306:3306"
restart: always
environment:
MYSQL_ROOT_PASSWORD: ${DB_PASSWORD}
MYSQL_DATABASE: ${DB_DATABASE}
volumes:
- db_data:/var/lib/mysql
networks:
- internal_network

redis:
image: redis:latest
ports:
- "6379:6379"
restart: always
environment:
ALLOW_EMPTY_PASSWORD: "no"
REDIS_PASSWORD: ${REDIS_PASSWORD}
REDIS_DISABLE_COMMANDS: "FLUSHDB,FLUSHALL"
volumes:
- redis_data:/data
networks:
- internal_network

nginx:
image: nginx:latest
ports:
- "80:80"
volumes:
- ./misacom/:/var/www/html
- ./nginx.conf:/etc/nginx/nginx.conf
networks:
- internal_network
depends_on:
- app

volumes:
db_data:
redis_data:

networks:
internal_network:
driver: bridge
< /code>
Вот файл .env: < /p>


#MariaDB
DB_DATABASE=misacom
DB_USER=root
DB_PASSWORD=password
# DB_HOST=mysql
#Redis
REDIS_PASSWORD=your_redis_password
< /code>
А вот Dockerfile и Laravel .env: < /p>
FROM php:8.3.11-fpm

RUN apt-get update && \
apt-get install -y --no-install-recommends \
build-essential \
libpng-dev \
libjpeg-dev \
libwebp-dev \
libxpm-dev \
libfreetype6-dev \
libzip-dev \
zip \
unzip \
git \
libonig-dev \
libpq-dev \
mariadb-client \
&& rm -rf /var/lib/apt/lists/*

RUN docker-php-ext-configure gd --with-freetype --with-jpeg --with-webp \
&& docker-php-ext-install -j$(nproc) gd \
pdo \
pdo_mysql \
mbstring \
zip \
exif \
pcntl \
bcmath \
opcache

COPY --from=composer:latest /usr/bin/composer /usr/bin/composer

WORKDIR /var/www/html
COPY . .

RUN mkdir -p /var/www/.config/psysh \
&& chown -R www-data:www-data /var/www/html \
&& chmod -R 775 /var/www/html/storage \
/var/www/html/bootstrap/cache \
/var/www/.config

USER root
RUN composer install --no-interaction --optimize-autoloader --no-dev

USER www-data

EXPOSE 9000

CMD ["php-fpm"]
< /code>
и Laravel .env: < /p>
DB_CONNECTION=mysql
DB_HOST=172.18.0.3
DB_PORT=3306
DB_DATABASE=db-name
DB_USERNAME=root
DB_PASSWORD=password```

The issue I'm facing is that when I set MySQL as the host in Laravel, it fails to connect. I've tried entering the container and using -h mysql, and it works without any issues. However, when I set the host in the .env file, Laravel fails to connect and cannot find the database. The error message I receive is as follows:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db-name.sessions' doesn't exist (Connection: mysql, SQL: select * from `sessions` where `id` = ...)



Подробнее здесь: https://stackoverflow.com/questions/794 ... ound-error