0.はじめに

CakePHP4系でBakeしようとしたら、下記エラーが発生。

0-1.開発環境

key	value
CakePHP	4.4.8
PHP	7.4.29
MySQL	5.7.34
MAMP	-
phpMyAdmin	-

1. 試したこと

$ php bin/cake.php bake all Product

2. エラーメッセージ

CakePHPのWelcomeページには、CakePHP is able to connect to the database.となっている。

2022-12-13 04:29:09 error: [Cake\Database\Exception\MissingConnectionException] Connection to Mysql could not be established: SQLSTATE[HY000] [2002] No such file or directory in /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver.php on line 133
Exception Attributes: array (
  'driver' => 'Mysql',
  'reason' => 'SQLSTATE[HY000] [2002] No such file or directory',
)
Stack Trace:
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php:164
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Schema/SchemaDialect.php:51
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php:216
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Schema/Collection.php:53
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Connection.php:418
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/bake/src/Command/ModelCommand.php:87
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/bake/src/Command/AllCommand.php:115
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/BaseCommand.php:189
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/CommandRunner.php:334
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/CommandRunner.php:172
- /Applications/MAMP/htdocs/products-manager/bin/cake.php:12

Caused by: [PDOException] SQLSTATE[HY000] [2002] No such file or directory in /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver.php on line 125
Stack Trace:
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver.php:125
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php:70
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver.php:131
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php:164
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Schema/SchemaDialect.php:51
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php:216
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Schema/Collection.php:53
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Connection.php:418
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/bake/src/Command/ModelCommand.php:87
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/bake/src/Command/AllCommand.php:115
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/BaseCommand.php:189
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/CommandRunner.php:334
- /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/CommandRunner.php:172
- /Applications/MAMP/htdocs/products-manager/bin/cake.php:12

[Cake\Database\Exception\MissingConnectionException] Connection to Mysql could not be established: SQLSTATE[HY000] [2002] No such file or directory in /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver.php on line 133

Exception Attributes

array (
  'driver' => 'Mysql',
  'reason' => 'SQLSTATE[HY000] [2002] No such file or directory',
)

Stack Trace:

#0 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php(164): Cake\Database\Driver->_connect('mysql:host=loca...', Array)
#1 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Schema/SchemaDialect.php(51): Cake\Database\Driver\Mysql->connect()
#2 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php(216): Cake\Database\Schema\SchemaDialect->__construct(Object(Cake\Database\Driver\Mysql))
#3 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Schema/Collection.php(53): Cake\Database\Driver\Mysql->schemaDialect()
#4 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Connection.php(418): Cake\Database\Schema\Collection->__construct(Object(Cake\Database\Connection))
#5 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/bake/src/Command/ModelCommand.php(87): Cake\Database\Connection->getSchemaCollection()
#6 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/bake/src/Command/AllCommand.php(115): Bake\Command\ModelCommand->execute(Object(Cake\Console\Arguments), Object(Cake\Console\ConsoleIo))
#7 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/BaseCommand.php(189): Bake\Command\AllCommand->execute(Object(Cake\Console\Arguments), Object(Cake\Console\ConsoleIo))
#8 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/CommandRunner.php(334): Cake\Console\BaseCommand->run(Array, Object(Cake\Console\ConsoleIo))
#9 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/CommandRunner.php(172): Cake\Console\CommandRunner->runCommand(Object(Bake\Command\AllCommand), Array, Object(Cake\Console\ConsoleIo))
#10 /Applications/MAMP/htdocs/products-manager/bin/cake.php(12): Cake\Console\CommandRunner->run(Array)
#11 {main}

Caused by [PDOException] SQLSTATE[HY000] [2002] No such file or directory in /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver.php on line 125

Stack Trace:

#0 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver.php(125): PDO->__construct('mysql:host=loca...', 'cakephp', 'password', Array)
#1 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php(70): Cake\Database\Driver->Cake\Database\{closure}()
#2 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver.php(131): Cake\Core\Retry\CommandRetry->run(Object(Closure))
#3 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php(164): Cake\Database\Driver->_connect('mysql:host=loca...', Array)
#4 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Schema/SchemaDialect.php(51): Cake\Database\Driver\Mysql->connect()
#5 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php(216): Cake\Database\Schema\SchemaDialect->__construct(Object(Cake\Database\Driver\Mysql))
#6 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Schema/Collection.php(53): Cake\Database\Driver\Mysql->schemaDialect()
#7 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Database/Connection.php(418): Cake\Database\Schema\Collection->__construct(Object(Cake\Database\Connection))
#8 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/bake/src/Command/ModelCommand.php(87): Cake\Database\Connection->getSchemaCollection()
#9 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/bake/src/Command/AllCommand.php(115): Bake\Command\ModelCommand->execute(Object(Cake\Console\Arguments), Object(Cake\Console\ConsoleIo))
#10 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/BaseCommand.php(189): Bake\Command\AllCommand->execute(Object(Cake\Console\Arguments), Object(Cake\Console\ConsoleIo))
#11 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/CommandRunner.php(334): Cake\Console\BaseCommand->run(Array, Object(Cake\Console\ConsoleIo))
#12 /Applications/MAMP/htdocs/products-manager/vendor/cakephp/cakephp/src/Console/CommandRunner.php(172): Cake\Console\CommandRunner->runCommand(Object(Bake\Command\AllCommand), Array, Object(Cake\Console\ConsoleIo))
#13 /Applications/MAMP/htdocs/products-manager/bin/cake.php(12): Cake\Console\CommandRunner->run(Array)
#14 {main}

3. 解決方法

app_local.phpに下記追記。

config/app_local.php

'Datasources' => [
    'default' => [
        //中略
+       'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',
    ],
],

Reference