In Rails 2.0, when you generate a new app, Rails defaults to SQLite3 as the default database adapter in database.yml. If you’d rather it generate database.yml for MySQL, you can use the following command to generate your app:

rails -d mysql myapp

Courtesy: Rails 2.0.2: Some new defaults and a few fixes