Question: I am trying to start CakePHP. I made bookmarker and tested by command `bin\cake server`. It showed one error as connection to database could not be established: 

`SQLSTATE[HY000] [1045] Access denied for user 'my_app'@'localhost' (using password: YES).`

I read the `config/app.default.php` file. It says there is a database `my_app` and another database `test_myapp` with some users. I can not find these databases in phymyadmin in xampp. Am I supposed to create the named databases and users manually? I thought CakePHP should create these automatically. Or should I give names of databases etc. which I like and create the same.I'm using xampp with windows 7 and am very new to CakePHP.

Answer: 
* Edit **Config/app\_local.php** file instead of *Config/app.php* with your database connection parameters, i.e. host, username, password, database name. This will solve the problem.
* *Be sure to create same database first and providing enough privileges to same user you're writing in app\_local.php file.*
Error:

> 
> SQLSTATE[HY000] [1045] Access denied for user 'my\_app'@'localhost'
>  (using password: YES).
> 
> 
> 

Reason: 

> 
> No user id: "my\_app" with password: "secret" [or any other] set in config/app.php
>  file.
> 
> 
> 

Solution:

> 
> In case of WAMP, go to phpmyadmin page, then we can select cake\_cms
>  database -> privilage-> create user id and password, same as in config
>  file config/app.php, refresh the <http://localhost:8765/> page.
>  it should now show
> 
> 
> CakePHP is able to connect to the database.
> 
> 
>