# Switch database adapter

**URL:** <https://www.ruby-forum.com/t/switch-database-adapter/127003>\
**Category:** Rails\
**Created:** [January 24, 2008, 3:02am UTC](https://www.ruby-forum.com/t/switch-database-adapter/127003 "2008-01-24T03:02:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jurincie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/48db29/32.png) [@jurincie](https://www.ruby-forum.com/u/jurincie)\
**Post date:** [January 24, 2008, 3:02am UTC](https://www.ruby-forum.com/t/switch-database-adapter/127003/1 "2008-01-24T03:02:52Z")

</div>

newbie question:

I am starting a new application via:

$ rails myapp

when I startup the webrick server via:

$ server/script webrick

and then goto [http://localhost:3000/](http://localhost:3000/) and click on: “About your  
applications environment”

it shows I am using the sqlite3 Databse Adapter.

How can I force my default db to be mysql?

Thanks

Ron

---

<div class="post-metadata">

**Author:** ![jurincie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/48db29/32.png) [@jurincie](https://www.ruby-forum.com/u/jurincie)\
**Post date:** [January 24, 2008, 3:11am UTC](https://www.ruby-forum.com/t/switch-database-adapter/127003/2 "2008-01-24T03:11:04Z")

</div>

your environment/database.yml should look like it :  
development:  
adapter: mysql  
encoding: utf8  
database: mydb\_development  
username: my\_username  
password: my\_password  
host: localhost

do the same for production et test environements

---

<div class="post-metadata">

**Author:** ![jurincie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/48db29/32.png) [@jurincie](https://www.ruby-forum.com/u/jurincie)\
**Post date:** [January 24, 2008, 4:10am UTC](https://www.ruby-forum.com/t/switch-database-adapter/127003/3 "2008-01-24T04:10:06Z")

</div>

On 24 Jan., 03:02, jurincie [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> $ rails myapp

Run…

$ rails -d mysql myapp

to preconfigure your app with mysql (or any other adapter). ah and  
btw… have a look at the other arguments of the rails command too, run  
`rails --help`.

---

<div class="post-metadata">

**Author:** ![jurincie](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/48db29/32.png) [@jurincie](https://www.ruby-forum.com/u/jurincie)\
**Post date:** [January 24, 2008, 4:44am UTC](https://www.ruby-forum.com/t/switch-database-adapter/127003/4 "2008-01-24T04:44:02Z")

</div>

Thank you…couldn’t find that anywhere!  
Ron