问题描述
还有其他几篇关于此的帖子,但似乎没有一个答案对我有用.
There have been several other posts about this, but none of the answers seemed to work for me.
当我在本地机器上导航到 CakePHP 页面时,出现一个错误:
When I navigate to the CakePHP page on my local machine, there is one error:
Cake 无法连接到数据库.数据库连接Mysql"缺失或无法创建.
Cake is NOT able to connect to the database. Database connection "Mysql" is missing, or could not be created.
当我在 home.ctp 中运行 这个有用的代码时,我得到以下回复:
When I run this helpful code in my home.ctp, I get the following response:
错误!:SQLSTATE[42000] [1049] 未知数据库 'test'
Error!: SQLSTATE[42000] [1049] Unknown database 'test'
但是,我的 Users/Ben/Sites/myapp/app/Config/database.php 看起来像这样(我设置 MAMP 以在 Users/Ben/Sites 中查找文档根目录):
However, my Users/Ben/Sites/myapp/app/Config/database.php looks like this (I set MAMP to look for the document root in Users/Ben/Sites):
<?php class DATABASE_CONFIG { public $default = array( 'datasource' => 'Database/Mysql', 'persistent' => false, 'host' => 'localhost', 'login' => 'Ben', 'password' => 'mypass', 'database' => 'CV', ); }
我创建了一个名为 Ben 的 mysql 用户,密码为 mypass,并在其下创建了一个名为 CV 的数据库.此外,我在任何地方都找不到 test 数据库的提及.有帮助吗?
I have created a mysql user called Ben with password mypass and created a database called CV under that. Moreover, I can't find mention of a test database anywhere. Help?
推荐答案
尝试添加套接字:
'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',