# How to create database mysql

**URL:** <https://www.ruby-forum.com/t/how-to-create-database-mysql/136380>\
**Category:** Rails\
**Created:** [May 1, 2008, 1:36pm UTC](https://www.ruby-forum.com/t/how-to-create-database-mysql/136380 "2008-05-01T13:36:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mani](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/b4bc9f/32.png) [@mani](https://www.ruby-forum.com/u/mani)\
**Post date:** [May 1, 2008, 1:36pm UTC](https://www.ruby-forum.com/t/how-to-create-database-mysql/136380/1 "2008-05-01T13:36:16Z")

</div>

it is creating database.yml in sqlite format  
how can i create database in mydql

---

<div class="post-metadata">

**Author:** ![mani](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/b4bc9f/32.png) [@mani](https://www.ruby-forum.com/u/mani)\
**Post date:** [May 1, 2008, 3:07pm UTC](https://www.ruby-forum.com/t/how-to-create-database-mysql/136380/2 "2008-05-01T15:07:34Z")

</div>

Manika Suri wrote:

> it is creating database.yml in sqlite format  
> how can i create database in mydql

rails appname -d mysql

or just alter your existing datbase.yml to reference the correct  
adapter:

development:  
adapter: mysql  
database: yourdb\_dev  
username: username  
password: password

# socket: /var/run/mysqld/mysqld.sock

socket is needed for Ubuntu, but not Windows in my experience. Can’t  
speak for any other \*nix-like OS’s.

---

<div class="post-metadata">

**Author:** ![mani](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/b4bc9f/32.png) [@mani](https://www.ruby-forum.com/u/mani)\
**Post date:** [May 1, 2008, 4:12pm UTC](https://www.ruby-forum.com/t/how-to-create-database-mysql/136380/3 "2008-05-01T16:12:41Z")

</div>

And just to help a bit more, in Rails 2.x you can now:

rake db:create:all

That will take the definitions in database.yml and actually create the  
db’s

---

<div class="post-metadata">

**Author:** ![mani](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/b4bc9f/32.png) [@mani](https://www.ruby-forum.com/u/mani)\
**Post date:** [May 1, 2008, 5:19pm UTC](https://www.ruby-forum.com/t/how-to-create-database-mysql/136380/4 "2008-05-01T17:19:40Z")

</div>

When you create your app w/the ‘rails’ command use the -d (database)  
option to specify the db to use. So:

rails my\_cool\_app -d mysql

HTH,

-Roy