problem with my database.yml - access denied

rubyonrails-talk
1

Trying to get Rails up and running on my webhost and I keep getting an error when I try to generate the scaffolding.

here is there error: Access denied for user 'kgreer'@'localhost' to database 'kgreer_DbMain'

Can I put my password "in the clear" in the database.yml? or am I supposed to do some kind of hash of the password? I am using mySQL 5 as the database.

Also my password ends in an exclamation character. This doesn't need to be escaped in YAML does it?

Thanks, Kelly Greer kellygreer1@nospam.com replace nospam with yahoo

2

Hi Kelly,

kellygreer1 wrote:

Trying to get Rails up and running on my webhost and I keep getting an error when I try to generate the scaffolding.

here is there error: Access denied for user 'kgreer'@'localhost' to database 'kgreer_DbMain'

Can I put my password "in the clear" in the database.yml?

Yes. The entry in database.yml is clear text.

Also my password ends in an exclamation character. This doesn't need to be escaped in YAML does it?

Never heard of a problem, but don't know about the exclamation character for sure.

Best regards Bill