# Access denied for user 'root'@'localhost'

**URL:** <https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/136445>\
**Category:** Rails\
**Created:** [May 2, 2008, 7:13am UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/136445 "2008-05-02T07:13:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mani](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/b4bc9f/32.png) [@mani](https://www.ruby-forum.com/u/mani)\
**Post date:** [May 2, 2008, 7:13am UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/136445/1 "2008-05-02T07:13:36Z")

</div>

I am getting error  
Access denied for user ‘root’@‘localhost’ (using password: NO)

i saw in database.yaml  
Install MySQL and put its /bin directory on your path.  
how to set it

---

<div class="post-metadata">

**Author:** ![mani](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/b4bc9f/32.png) [@mani](https://www.ruby-forum.com/u/mani)\
**Post date:** [May 2, 2008, 7:37am UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/136445/2 "2008-05-02T07:37:08Z")

</div>

Manika Suri wrote:

> I am getting error  
> Access denied for user ‘root’@‘localhost’ (using password: NO)
> 
> i saw in database.yaml  
> Install MySQL and put its /bin directory on your path.  
> how to set it

Example app\_name/config/database.yml :

development:  
adapter: mysql  
database: teapoci\_development  
username: root  
password:  
host: localhost

make sure that your database login in mysql is correct, like password or  
username.

---

<div class="post-metadata">

**Author:** ![mani](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/b4bc9f/32.png) [@mani](https://www.ruby-forum.com/u/mani)\
**Post date:** [May 22, 2008, 3:05pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/136445/3 "2008-05-22T15:05:39Z")

</div>

Manika Suri wrote:

> I am getting error  
> Access denied for user ‘root’@‘localhost’ (using password: NO)
> 
> i saw in database.yaml  
> Install MySQL and put its /bin directory on your path.  
> how to set it

You may also have to log on to MySQl as root with -P option and GRANT  
permission for root to access the database.