CakePHP Database connection "Mysql" is missing, or could not be created

Question

There have been several other posts about this, but none of the answers seemed to work for me.

When I navigate to the CakePHP page on my local machine, there is one error:

Cake is NOT able to connect to the database. Database connection "Mysql" is missing, or could not be created.

When I run this helpful code in my home.ctp, I get the following response:

Error!: SQLSTATE[42000] [1049] Unknown database 'test'

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',     ); } 

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?

Answer 1

Try adding the socket:

'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock', 

Answer 2

An alternative to unix_socket (especially for OS X people) is to replace localhost with 127.0.0.1

Would be as Follows :

public $default = array(                 'datasource' => 'Database/Mysql',                 'persistent' => false,                 'host' => '127.0.0.1',                 'login' => 'user',                 'password' => 'password',                 'database' => 'database-name',                 'prefix' => '',                 'encoding' => 'utf8',         );