laravel - Laravel 无法使用 Docker Compose 连接到数据库

问题描述

我正在开发一个 Laravel 应用程序，尝试将 Docker 作为开发环境。我正在使用 Docker Compose 来编排 docker。我现在无法连接到数据库。这是我到目前为止所做的。

我docker-compose.yml在项目根文件夹中创建了一个。

version: '3'
services:
    apache:
        container_name: easy_eat_apache
        image: webdevops/apache:ubuntu-16.04
        environment:
            WEB_DOCUMENT_ROOT: /var/www/public
            WEB_ALIAS_DOMAIN: easy-eat.localhost
            WEB_PHP_SOCKET: php-fpm:9000
        volumes: # Only shared dirs to apache (to be served)
        - ./public:/var/www/public:cached
        - ./storage:/var/www/storage:cached
        networks:
        - easy-eat-network
        ports:
        - "80:80"
        - "443:443"
    php-fpm:
        container_name: easy_eat_php
        image: jguyomard/laravel-php:7.2
        volumes:
        - ./:/var/www/
        - ./ci:/var/www/ci:cached
        - ./vendor:/var/www/vendor:delegated
        - ./storage:/var/www/storage:delegated
        - ./node_modules:/var/www/node_modules:cached
        - ~/.ssh:/root/.ssh:cached
        - ~/.composer/cache:/root/.composer/cache:delegated
        networks:
        - easy-eat-network
    db:
        container_name: easy_eat_db
        image: mariadb:10.2
        environment:
            MYSQL_ROOT_PASSWORD: root
            MYSQL_DATABASE: easy_eat
            MYSQL_USER: easy_eat
            MYSQL_PASSWORD: secret
        volumes:
        - db_data:/var/lib/mysql
        networks:
        - easy-eat-network
        ports:
        - "33060:3306"
networks:
    easy-eat-network:
        driver: "bridge"
volumes:
    db_data:
        driver: "local"

然后我运行以下命令来启动环境。

docker-compose up --build -d

我像这样修改了 env 文件中的数据库凭据。

DB_CONNECTION=mysql
DB_HOST=db
DB_PORT=3306
DB_DATABASE=easy_eat
DB_USERNAME=easy_eat
DB_PASSWORD=secret

为了确保我的 laravel 应用程序可以连接到数据库，我运行迁移命令如下。

docker-compose exec php-fpm php artisan migrate:fresh --seed

我收到以下错误。

Illuminate\Database\QueryException  : SQLSTATE[HY000] [1045] Access denied for user 'easy_eat'@'172.25.0.4' (using password: YES) (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')

  at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668| 

  Exception trace:

  1   PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'easy_eat'@'172.25.0.4' (using password: YES)")
      /var/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70

  2   PDO::__construct("mysql:host=db;port=3306;dbname=easy_eat", "easy_eat", "secret", [])
      /var/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70

设置有什么问题，我该如何解决？

标签： laraveldockerdocker-compose

laravel - Laravel 无法使用 Docker Compose 连接到数据库

问题描述

解决方案

推荐阅读