# How to use MySQL instead of sqlite3

**URL:** <https://www.ruby-forum.com/t/how-to-use-mysql-instead-of-sqlite3/137836>\
**Category:** Ruby\
**Created:** [May 16, 2008, 7:30pm UTC](https://www.ruby-forum.com/t/how-to-use-mysql-instead-of-sqlite3/137836 "2008-05-16T19:30:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex\_Chun](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e495f1/32.png) [@Alex\_Chun](https://www.ruby-forum.com/u/Alex_Chun)\
**Post date:** [May 16, 2008, 7:30pm UTC](https://www.ruby-forum.com/t/how-to-use-mysql-instead-of-sqlite3/137836/1 "2008-05-16T19:30:45Z")

</div>

The current release of Ruby on Rails uses sqlite3 as its default  
database.

[http://weblog.infoworld.com/tcdaily/archives/2008/01/ruby\_on\_rails\_g.html](http://weblog.infoworld.com/tcdaily/archives/2008/01/ruby_on_rails_g.html)

How can I set Ruby on Rails to use MySQL? I tried

```
gem install mysql

```

but new projects still default to using sqlite3.

Thanks.

Alex

---

<div class="post-metadata">

**Author:** ![Alex\_Chun](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e495f1/32.png) [@Alex\_Chun](https://www.ruby-forum.com/u/Alex_Chun)\
**Post date:** [May 16, 2008, 7:36pm UTC](https://www.ruby-forum.com/t/how-to-use-mysql-instead-of-sqlite3/137836/2 "2008-05-16T19:36:41Z")

</div>

> How can I set Ruby on Rails to use MySQL? I tried
> 
> gem install mysql
> 
> but new projects still default to using sqlite3.

For existing projects you should chage database.yml, for new projects  
you can use rails -d mysql project\_name

Regards,  
Rimantas

---

<div class="post-metadata">

**Author:** ![Alex\_Chun](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e495f1/32.png) [@Alex\_Chun](https://www.ruby-forum.com/u/Alex_Chun)\
**Post date:** [May 16, 2008, 7:39pm UTC](https://www.ruby-forum.com/t/how-to-use-mysql-instead-of-sqlite3/137836/3 "2008-05-16T19:39:02Z")

</div>

-----BEGIN PGP SIGNED MESSAGE-----  
Hash: SHA1

Alex Chun wrote:  
| The current release of Ruby on Rails uses sqlite3 as its default database.  
|  
| [http://weblog.infoworld.com/tcdaily/archives/2008/01/ruby\_on\_rails\_g.html](http://weblog.infoworld.com/tcdaily/archives/2008/01/ruby_on_rails_g.html)  
|  
| How can I set Ruby on Rails to use MySQL? I tried  
|  
| gem install mysql  
|  
| but new projects still default to using sqlite3.

1. Rails questions are better asked the Rails community:  
[Ruby on Rails — Community](http://rubyonrails.com/community)

2. rails -d mysql, IIRC.

* * *

Phillip G.  
Twitter: [twitter.com/cynicalryan](http://twitter.com/cynicalryan)  
Blog: [http://justarubyist.blogspot.com](http://justarubyist.blogspot.com)

~ - You know you’ve been hacking too long when…  
…your speech is punctuated by finger twitches (or arm-waving)  
indicating  
braces.  
-----BEGIN PGP SIGNATURE-----  
Version: GnuPG v1.4.8 (MingW32)  
Comment: Using GnuPG with Mozilla - [http://enigmail.mozdev.org](http://enigmail.mozdev.org)

iEYEARECAAYFAkgtxnIACgkQbtAgaoJTgL+xAwCfaxFbIEM1Kv+exDe1dpAwZsy8  
kRkAoJfFB01AmVgVaOE0tJs4+1Ld8quj  
=I/o5  
-----END PGP SIGNATURE-----