cakephp bake console error Exception: SQLSTATE[HY000] [2002] No such file or directory in

I’m trying to follow the CakePHP tutorial for tags and users here.: https://book.cakephp.org/3/en/tutorials-and-examples/cms/tags-and-users.html

However, I keep encountering this error for bin/cake bake model users and bin/cake bake template users.

bin/cake bake controller users works fine.

I tried changing the database host to ‘host’ => ‘127.0.0.1’ but it still shows the same error.

Does anyone know how to solve this? I’m using CakePHP in vagrant environment on Mac OS. Thank you!

This is what the error says for both model users and template users command.

Exception: SQLSTATE[HY000] [2002] No such file or directory in [/home/vagrant/app/vendor/cakephp/cakephp/src/Database/Driver.php, line 93]
2024-03-20 09:01:03 Error: [PDOException] SQLSTATE[HY000] [2002] No such file or directory in /home/vagrant/app/vendor/cakephp/cakephp/src/Database/Driver.php on line 93
Stack Trace:
#0 /home/vagrant/app/vendor/cakephp/cakephp/src/Database/Driver.php(93): PDO->__construct('mysql:host=loca...', 'my_app', 'secret', Array)
#1 /home/vagrant/app/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php(105): CakeDatabaseDriver->_connect('mysql:host=loca...', Array)
#2 /home/vagrant/app/vendor/cakephp/cakephp/src/Database/Schema/BaseSchema.php(44): CakeDatabaseDriverMysql->connect()
#3 /home/vagrant/app/vendor/cakephp/cakephp/src/Database/Dialect/MysqlDialectTrait.php(62): CakeDatabaseSchemaBaseSchema->__construct(Object(CakeDatabaseDriverMysql))
#4 /home/vagrant/app/vendor/cakephp/cakephp/src/Database/Schema/Collection.php(51): CakeDatabaseDriverMysql->schemaDialect()
#5 /home/vagrant/app/vendor/cakephp/cakephp/src/Database/Schema/CachedCollection.php(41): CakeDatabaseSchemaCollection->__construct(Object(CakeDatabaseConnection))
#6 /home/vagrant/app/vendor/cakephp/cakephp/src/Database/Connection.php(399): CakeDatabaseSchemaCachedCollection->__construct(Object(CakeDatabaseConnection), true)
#7 /home/vagrant/app/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(1096): CakeDatabaseConnection->getSchemaCollection()
#8 /home/vagrant/app/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(1050): BakeShellTaskModelTask->_getAllTables()
#9 /home/vagrant/app/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(213): BakeShellTaskModelTask->listAll()
#10 /home/vagrant/app/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(131): BakeShellTaskModelTask->getAssociations(Object(CakeORMTable))
#11 /home/vagrant/app/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(114): BakeShellTaskModelTask->getTableContext(Object(CakeORMTable), 'users', 'Users')
#12 /home/vagrant/app/vendor/cakephp/bake/src/Shell/Task/ModelTask.php(101): BakeShellTaskModelTask->bake('Users')
#13 /home/vagrant/app/vendor/cakephp/cakephp/src/Console/Shell.php(531): BakeShellTaskModelTask->main('users')
#14 /home/vagrant/app/vendor/cakephp/cakephp/src/Console/Shell.php(524): CakeConsoleShell->runCommand(Array, false, Array)
#15 /home/vagrant/app/vendor/cakephp/cakephp/src/Console/CommandRunner.php(384): CakeConsoleShell->runCommand(Array, true)
#16 /home/vagrant/app/vendor/cakephp/cakephp/src/Console/CommandRunner.php(162): CakeConsoleCommandRunner->runShell(Object(BakeShellBakeShell), Array)
#17 /home/vagrant/app/bin/cake.php(12): CakeConsoleCommandRunner->run(Array)
#18 {main}

Any help would be appreciated. Thank you so much.