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

**URL:** <https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671>\
**Category:** Rails\
**Created:** [December 19, 2007, 5:09pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671 "2007-12-19T17:09:55Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [December 19, 2007, 5:09pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671/1 "2007-12-19T17:09:55Z")

</div>

Hi guys,  
You know the simple “Hello World!” application which get rails to say on  
a web page “Hello World!”, yeah? Well i’m am having trouble with it.  
Everytime i go onto the [http://localhost:3000/say/hello](http://localhost:3000/say/hello) it come up with  
this:

Mysql::Error in SayController#hello  
#28000Access denied for user ‘root’@‘localhost’ (using password: NO)  
RAILS\_ROOT: C:/ruby/demo

I have a password and i am not using a database  
I have put my password into the database.yml file and this still comes  
up  
What should i do?  
Thanks  
Chris

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [December 19, 2007, 5:13pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671/2 "2007-12-19T17:13:14Z")

</div>

On 19 Dec 2007, at 16:09, Chris W. wrote:

> Mysql::Error in SayController#hello  
> #28000Access denied for user ‘root’@‘localhost’ (using password: NO)  
> RAILS\_ROOT: C:/ruby/demo

What exactly is in your database.yml ?

Fred

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [December 19, 2007, 5:16pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671/3 "2007-12-19T17:16:00Z")

</div>

development:  
adapter: mysql  
encoding: utf8  
database: demo\_development  
username: root  
password: \*\*\*\*\*\*\*  
host: localhost

test:  
adapter: mysql  
encoding: utf8  
database: demo\_test  
username: root  
password: \*\*\*\*\*\*\*  
host: localhost

production:  
adapter: mysql  
encoding: utf8  
database: demo\_production  
username: root  
password: \*\*\*\*\*\*\*  
host: localhost

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [December 19, 2007, 5:35pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671/4 "2007-12-19T17:35:30Z")

</div>

On 19 Dec 2007, at 16:16, Chris W. wrote:

Can you connect on the command line with

mysql -u root -p demo\_development

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [December 19, 2007, 5:50pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671/5 "2007-12-19T17:50:51Z")

</div>

no but this app doesn’t include a db  
its the simplest thing!

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [December 19, 2007, 7:22pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671/6 "2007-12-19T19:22:44Z")

</div>

help!

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [December 19, 2007, 7:37pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671/7 "2007-12-19T19:37:58Z")

</div>

Chris W. wrote:

> help!

well, ruby/rails assumes a database.  
if you want to go topless, here is  
a way to do it. it will take a little bit  
of effort.

> **[NoDatabase.pdf](https://media.pragprog.com/titles/fr_rr/NoDatabase.pdf)**
>
> 95.57 KB

but i would hook up a mysql database with one dubby table.  
up to you.

:)))))))))

there may be other idea’s somewhere.

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [December 19, 2007, 7:42pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671/8 "2007-12-19T19:42:30Z")

</div>

thanks i tried it with a table and it worked!  
thanks m8  
chris

---

<div class="post-metadata">

**Author:** ![supasta](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ebca7d/32.png) [@supasta](https://www.ruby-forum.com/u/supasta)\
**Post date:** [December 19, 2007, 6:13pm UTC](https://www.ruby-forum.com/t/access-denied-for-user-root-localhost/123671/9 "2007-12-19T18:13:47Z")

</div>

any ideas?