20
Help us understand the problem. What are the problem?

More than 1 year has passed since last update.

posted at

updated at

Laravel tinker データベースの接続できるか疎通確認する

$ php artisan tinker

データベースに接続できるか確認する

簡単なのはSELECT文が通るか実行して確認します。」

>>> DB::select('select 1');
=> [
     {#3046
       +"1": 1,
     },
   ]

このような結果が返れば、少なくともデータベースに接続できています。

データベースに接続できない場合

データベース接続設定内容を確認します。

$ php artisan tinker
>>> config('database.default')
=> "mysql"

>>> config('database.connections.mysql')
=> [
     "driver" => "mysql",
     "url" => null,
     "host" => "db",
     "port" => "3306",
     "database" => "laravel_local",
     "username" => "phper",
     "password" => "secret",
     "unix_socket" => "",
     "charset" => "utf8mb4",
     "collation" => "utf8mb4_unicode_ci",
     "prefix" => "",
     "prefix_indexes" => true,
     "strict" => true,
     "engine" => null,
     "options" => [],
   ]

>>> DB::connection()->getConfig();
=> [
     "driver" => "mysql",
     "host" => "db",
     "port" => "3306",
     "database" => "laravel_local",
     "username" => "phper",
     "password" => "secret",
     "unix_socket" => "",
     "charset" => "utf8mb4",
     "collation" => "utf8mb4_unicode_ci",
     "prefix" => "",
     "prefix_indexes" => true,
     "strict" => true,
     "engine" => null,
     "options" => [],
     "name" => "mysql",
   ]

>>> DB::connection()->getPdo();
=> PDO {#3051
     inTransaction: false,
     attributes: {
       CASE: NATURAL,
       ERRMODE: EXCEPTION,
       AUTOCOMMIT: 1,
       PERSISTENT: false,
       DRIVER_NAME: "mysql",
       SERVER_INFO: "Uptime: 859  Threads: 3  Questions: 42  Slow queries: 0  Opens: 116  Flush tables: 3  Open tables: 36  Queries per second avg: 0.048",
       ORACLE_NULLS: NATURAL,
       CLIENT_VERSION: "mysqlnd 7.4.4",
       SERVER_VERSION: "8.0.19",
       STATEMENT_CLASS: [
         "PDOStatement",
       ],
       EMULATE_PREPARES: 0,
       CONNECTION_STATUS: "db via TCP/IP",
       DEFAULT_FETCH_MODE: BOTH,
     },
   }

この結果と .env 等の設定を比較して正しい設定が行われているか確認します。

参考

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Sign upLogin
20
Help us understand the problem. What are the problem?