首页 > 解决方案 > 连接错误:SQLSTATE[HY000] [2002] cakephp 烘焙模型和模板

问题描述

(macOS Catalina / PHP 7.4.2 / Homebrew and intl installed / MAMP)

1 - ./cake bake controller users:它对我有用,并使用来自用烘焙创建的 UsersController 的视图功能显示数据库中的数据。

但是当我这样做时:

2: ./cake bake template users./cake bake model users

我收到此错误:无法建立与 Mysql 的连接:SQLSTATE[HY000] [2002] 没有这样的文件或目录

3:当我尝试时: ./cake bake template all./cake bake model all

Exception: Connection to Mysql could not be established: SQLSTATE[HY000] [2002] No such file or directory

[/Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Database/Driver.php, line 107]

Error: [Cake\Database\Exception\MissingConnectionException] Connection to Mysql could not be established: SQLSTATE[HY000] [2002] No such file or directory in /Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Database/Driver.php on line 107
Exception Attributes: array (
  'driver' => 'Mysql',
  'reason' => 'SQLSTATE[HY000] [2002] No such file or directory',
)
Stack Trace:
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php:114
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Database/Schema/BaseSchema.php:47
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Database/Dialect/MysqlDialectTrait.php:65
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Database/Schema/Collection.php:53
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Database/Connection.php:400
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/bake/src/Utility/TableScanner.php:65
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/bake/src/Utility/TableScanner.php:82
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/bake/src/Command/TemplateAllCommand.php:60
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Console/BaseCommand.php:175
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Console/CommandRunner.php:336
- /Applications/MAMP/htdocs/cake4/vendor/cakephp/cakephp/src/Console/CommandRunner.php:171
- /Applications/MAMP/htdocs/cake4/bin/cake.php:12

PS:我已经添加 export PATH=/Applications/MAMP/bin/php/php7.4.11/bin:$PATH到 ~/.bash_profile

CakePHP3 上的同样错误。有什么帮助吗?

标签: databasetemplatescakephpcontrollerconnection

解决方案


推荐阅读