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

php macos mysql mamp cakephp

2022-08-30 13:14:56

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 looks like this (I set MAMP to look for the document root in Users/Ben/Sites):Users/Ben/Sites/myapp/app/Config/database.php

<?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 with password and created a database called under that. Moreover, I can't find mention of a database anywhere. Help?BenmypassCVtest

答案 1

Try adding the socket:

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

答案 2

An alternative to (especially for OS X people) is to replace with unix_socketlocalhost127.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',
        );