mysql problem

hi. im new to rails. how do i set mysql to be my default database?
when i open the .yml file its always set to sqllite. im following this
book called 'railsspace' and it says i should use mysql but i cant
because its been giving me problems. thanks!

To make a rails app defaulting to mysql use
rails -d mysql yourappname

But if you did not do this all you have to do is change it in database.yml.

There is no need to use mysql if you don't want to. You can use
sqlite or postgresql instead.

Have you seen the rails guides at
http://guides.rubyonrails.org/getting_started.html? The getting
started guide covers this and is a good intro for beginners. Also the
other guides and the railscasts are very good.

Colin

Hi

Is there a way i can provide mysql password while creating rails application ?

Specify rails version while creating new rails project
http://funonrails.wordpress.com/2009/04/20/specify-rails-version-to-use-while-creating-rails-project/

Sandip R~

no.

if you call rails with -d mysql, rails generates a sample config as
config/database.yml, you can specify the details there.