时间戳

首页 > 解决方案 > 不能用 docker laravel 做 mysql

mysql - 不能用 docker laravel 做 mysql

问题描述

当我使用 docker 启动的容器运行 php artisan migrate 时，会出现以下错误。是 root@xxxxxx:/#php artisan migrate 随容器启动而迁移，还是 $php artisan migrate 在另一个终端中？后者完成。

      Illuminate\Database\QueryException  : SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) (SQL: select * from information_schema.tables where table_schema = ogp and table_name = migrations and table_type = 'BASE TABLE')
Exception trace:

  1   PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)")
2   PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=ogp", "root", "pass", [])

    #docker-compose.yml
version: '3'

services:
  db:
    image: mysql:5.7
    command: >
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_unicode_ci
      --general-log=true
      --general-log-file=/var/log/mysql/general.log
    environment:
      - MYSQL_DATABASE=ogp
      - MYSQL_ROOT_PASSWORD=pass
      - MYSQL_USER=default
      - MYSQL_PASSWORD=password
      - TZ=Asia/Tokyo
    ports:
      - "3306:3306"

#.env
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=ogp
DB_USERNAME=root
DB_PASSWORD=pass

#database.php
'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],

标签： mysql

解决方案

您需要向您的数据库用户授予权限

GRANT ALL PRIVILEGES ON ogp.* TO 'root'@'127.0.0.1';

FLUSH PRIVILEGES;

推荐阅读