症状

CakePHP3.8でBakeしようとした時に、以下のようなエラーが出たので、この症状を解決します。

$ bin/cake bake model Articles
One moment while associations are detected.
Exception: SQLSTATE[HY000] [2002] No such file or directory in [/Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Database/Driver.php, line 92]
2020-04-16 01:18:27 Error: [PDOException] SQLSTATE[HY000] [2002] No such file or directory in /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Database/Driver.php on line 92
Stack Trace:
# 0 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Database/Driver.php(92): PDO->__construct('mysql:host=loca...', 'test_user', 'Test', Array)
# 1 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php(105): Cake\Database\Driver->_connect('mysql:host=loca...', Array)
# 2 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Database/Schema/BaseSchema.php(44): Cake\Database\Driver\Mysql->connect()
# 3 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Database/Dialect/MysqlDialectTrait.php(62): Cake\Database\Schema\BaseSchema->__construct(Object(Cake\Database\Driver\Mysql))
# 4 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Database/Schema/Collection.php(51): Cake\Database\Driver\Mysql->schemaDialect()
# 5 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Database/Schema/CachedCollection.php(41): Cake\Database\Schema\Collection->__construct(Object(Cake\Database\Connection))
# 6 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Database/Connection.php(390): Cake\Database\Schema\CachedCollection->__construct(Object(Cake\Database\Connection), true)
# 7 /Applications/MAMP/htdocs/blog/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(1096): Cake\Database\Connection->getSchemaCollection()
# 8 /Applications/MAMP/htdocs/blog/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(1050): Bake\Shell\Task\ModelTask->_getAllTables()
# 9 /Applications/MAMP/htdocs/blog/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(213): Bake\Shell\Task\ModelTask->listAll()
# 10 /Applications/MAMP/htdocs/blog/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(131): Bake\Shell\Task\ModelTask->getAssociations(Object(Cake\ORM\Table))
# 11 /Applications/MAMP/htdocs/blog/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(114): Bake\Shell\Task\ModelTask->getTableContext(Object(Cake\ORM\Table), 'articles', 'Articles')
# 12 /Applications/MAMP/htdocs/blog/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(101): Bake\Shell\Task\ModelTask->bake('Articles')
# 13 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Console/Shell.php(531): Bake\Shell\Task\ModelTask->main('Articles')
# 14 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Console/Shell.php(524): Cake\Console\Shell->runCommand(Array, false, Array)
# 15 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Console/CommandRunner.php(385): Cake\Console\Shell->runCommand(Array, true)
# 16 /Applications/MAMP/htdocs/blog/vendor/cakephp/cakephp/src/Console/CommandRunner.php(162): Cake\Console\CommandRunner->runShell(Object(Bake\Shell\BakeShell), Array)
# 17 /Applications/MAMP/htdocs/blog/bin/cake.php(12): Cake\Console\CommandRunner->run(Array)
# 18 {main}

アプリケーションのトップページでは、

CakePHP is able to connect to the database.

と表示されているのに、いざBakeするとDBエラーが出てしまうという感じです。

環境

CakePHP 3.8
PHP 7.3.8
MAMP
MySQL 5.7.26

Mac上のMAMPを用いてローカル環境でCakePHPの"blog"アプリケーションを作成していました。CakePHP3.8 - ブログチュートリアルです。

解決方法

blogアプリケーション内の

blog/config/app.php

のデータベース接続に関する記述を書き換えました。

'Datasources' => [
    'default' => [
        'className' => 'Cake\Database\Connection',
        'driver' => 'Cake\Database\Driver\Mysql',
        'persistent' => false,
        'host' => 'localhost',
        'port' => '8889', //MAMPのためportを設定しています。
        'username' => 'test_user',
        'password' => 'Test',
        'database' => 'cake_blog',
        //'encoding' => 'utf8mb4',
        'timezone' => 'UTC',
        'flags' => [],
        'cacheMetadata' => true,
        'log' => false,
        'quoteIdentifiers' => false,
        //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'],
        'url' => env('DATABASE_URL', null),

        //↓↓↓↓↓↓↓この一行を追加設定
        'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock'
        //↑↑↑↑↑↑↑
    ],
],

以上。