# Connecting with mysql

**URL:** <https://www.ruby-forum.com/t/connecting-with-mysql/136290>\
**Category:** Rails\
**Created:** [April 30, 2008, 2:13pm UTC](https://www.ruby-forum.com/t/connecting-with-mysql/136290 "2008-04-30T14:13:51Z")\
**Posts on this page:** 4\
**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:** [April 30, 2008, 2:13pm UTC](https://www.ruby-forum.com/t/connecting-with-mysql/136290/1 "2008-04-30T14:13:51Z")

</div>

I created new project with rails mysql -d   
but now I am creating controller I am getting error  
I also installed mysql with gem install mysql  
Access denied for user ‘root’@‘localhost’ (using password: NO)  
what is the solution?

---

<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:** [April 30, 2008, 2:57pm UTC](https://www.ruby-forum.com/t/connecting-with-mysql/136290/2 "2008-04-30T14:57:48Z")

</div>

On 30 Apr 2008, at 13:13, Manika Suri wrote:

> I created new project with rails mysql -d   
> but now I am creating controller I am getting error  
> I also installed mysql with gem install mysql  
> Access denied for user ‘root’@‘localhost’ (using password: NO)  
> what is the solution?

Make the username and password in your database.yml correspond to  
users with access to your database.

Fred

---

<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:** [April 30, 2008, 5:16pm UTC](https://www.ruby-forum.com/t/connecting-with-mysql/136290/3 "2008-04-30T17:16:17Z")

</div>

Does the root account in mysql need a password? If so, have you added  
that password to \<\>/config/database.yml?

---

<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 1, 2008, 1:09pm UTC](https://www.ruby-forum.com/t/connecting-with-mysql/136290/4 "2008-05-01T13:09:48Z")

</div>

Roy P. wrote:

> Does the root account in mysql need a password? If so, have you added  
> that password to \<\>/config/database.yml?  
> now tell mehow to create a database in sqlite with ruby on rails.and  
> connect with it .I m noot getting