Database configuration Issue CakePHP

Question

My database.php :

class DATABASE_CONFIG {
    public $default = array(
        'datasource' => 'Database/MySql',
        'persistent' => false,
        'host' => 'localhost',
        'login' => '',
        'password' => '',
        'database' => 'cake_database',
        'schema' => '',
        'prefix' => '',
        'encoding' => 'utf8'
    );

    public $test = array(
        'datasource' => 'Database/MySql',
        'persistent' => true,
        'host' => 'localhost',
        'login' => '',
        'password' => '',
        'database' => 'cake_database',
        'prefix' => '',
        //'encoding' => 'utf8',
    );
}

Shows this notice : CakePHP is NOT able to connect to the database.Database connection "Mysql" is missing, or could not be created.

Please help...........

Also the default login for MySQL is root. You don't have any user specified — Catalin MUNTEANU, Mar 17 '15 at 16:40
Well try specifying the user and the password if you set one when you installed wamp. — Catalin MUNTEANU, Mar 17 '15 at 16:43
possible duplicate of [CakePHP Database connection "Mysql" is missing, or could not be created](http://stackoverflow.com/questions/19280245/cakephp-database-connection-mysql-is-missing-or-could-not-be-created). There a few SO posts about this topic. — AgRizzo, Mar 17 '15 at 16:46
Finally I solved by changing following line in code . 'host' => '127.0.0.1', 'login' => 'root', Thanks for your respons..........Catalin Munteanu & AgRizzo — Monzur, Mar 17 '15 at 16:55
I'm pretty sure it wasn't cause by replacing `localhost` with `127.0.0.1`. The problem was the user not being specified. I'm glad you solved it. — Catalin MUNTEANU, Mar 17 '15 at 17:12
A note for u in the upcoming setup. By default, MySQL username will always be root..It cannot be empty. — Nizam, Jul 06 '15 at 05:10

score 0 · Answer 1 · answered Jan 27 '16 at 15:03

public $default = array( 'datasource' => 'Database/MySql', 'persistent' => false, 'host' => 'localhost', 'login' => 'root', 'password' => '', 'database' => 'cake_database', 'schema' => '', 'prefix' => '', 'encoding' => 'utf8' );

Mysql default login is root and password empty,

If you have change it, you must enter the user and the password to access database..

It's just because cakephp failed connect to mysql..

Database configuration Issue CakePHP

1 Answers1