Q&A
docker-compose.ymlまたDockerfileも載せていただくことは可能ですか？
前提・実現したいこと
Dockerでlaravelの環境を構築するのに、" php artisan migrate " をすると以下のエラーが起こってしまいます。
発生している問題・エラーメッセージ
Illuminate\Database\QueryException : SQLSTATE[HY000] [1045] Access denied for user 'default'@'172.19.0.5' (using password: YES) (SQL: select * from information_schema.tables where table_schema = default and table_name = migrations and table_type = 'BASE TABLE') at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:665 661| // If an exception occurs when attempting to run a query, we'll format the error 662| // message to include the bindings with SQL, which will make this exception a 663| // lot more helpful to the developer instead of just the database's errors. 664| catch (Exception $e) { > 665| throw new QueryException( 666| $query, $this->prepareBindings($bindings), $e 667| ); 668| } 669| Exception trace: 1 PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'default'@'172.19.0.5' (using password: YES)") /var/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70 2 PDO::__construct("mysql:host=mysql;port=3306;dbname=default", "default", "root", []) /var/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:70 3 Illuminate\Database\Connectors\Connector::createPdoConnection("mysql:host=mysql;port=3306;dbname=default", "default", "root", []) /var/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:46 4 Illuminate\Database\Connectors\Connector::createConnection("mysql:host=mysql;port=3306;dbname=default", []) /var/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php:24 5 Illuminate\Database\Connectors\MySqlConnector::connect() /var/www/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:182 6 Illuminate\Database\Connectors\ConnectionFactory::Illuminate\Database\Connectors\{closure}() /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:920 7 call_user_func(Object(Closure)) /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:920 8 Illuminate\Database\Connection::getPdo() /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:945 9 Illuminate\Database\Connection::getReadPdo() /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:400 10 Illuminate\Database\Connection::getPdoForSelect() /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:326 11 Illuminate\Database\Connection::Illuminate\Database\{closure}("select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE'") /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:658 12 Illuminate\Database\Connection::runQueryCallback("select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE'", Object(Closure)) /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 13 Illuminate\Database\Connection::run("select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE'", Object(Closure)) /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:334 14 Illuminate\Database\Connection::select("select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE'") /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php:18 15 Illuminate\Database\Schema\MySqlBuilder::hasTable("migrations") /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php:169 16 Illuminate\Database\Migrations\DatabaseMigrationRepository::repositoryExists() /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:585 17 Illuminate\Database\Migrations\Migrator::repositoryExists() /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:91 18 Illuminate\Database\Console\Migrations\MigrateCommand::prepareDatabase() /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:63 19 Illuminate\Database\Console\Migrations\MigrateCommand::handle() /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:32 20 call_user_func_array([]) /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:32 21 Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:90 22 Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Object(Closure)) /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:34 23 Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), []) /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php:591 24 Illuminate\Container\Container::call() /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php:192 25 Illuminate\Console\Command::execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) /var/www/vendor/symfony/console/Command/Command.php:255 26 Symfony\Component\Console\Command\Command::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php:179 27 Illuminate\Console\Command::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) /var/www/vendor/symfony/console/Application.php:915 28 Symfony\Component\Console\Application::doRunCommand(Object(Illuminate\Database\Console\Migrations\MigrateCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) /var/www/vendor/symfony/console/Application.php:272 29 Symfony\Component\Console\Application::doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) /var/www/vendor/symfony/console/Application.php:148 30 Symfony\Component\Console\Application::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) /var/www/vendor/laravel/framework/src/Illuminate/Console/Application.php:90 31 Illuminate\Console\Application::run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:131 32 Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) /var/www/artisan:37
該当のソースコード
DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=mybbs DB_USERNAME=root DB_PASSWORD=root
試したこと
エラーを調べながら変更などしましたが、エラーが一向に変わりませんでした。
よろしくお願いします。
自己解決
