How to make a Rails application using MySQL?

Question

To make a Rails application with MySQL, I do the following:

rails new application -database=mysql

That doesn't work though, instead it gives my SQLite. I don't want SQLite, I want MySQL.

How can I solve this?

maybe you need more than that stackoverflow.com/questions/5366934/… — Thai Tran
– Thai Tran, Commented Nov 11, 2012 at 7:25

Icicle · Accepted Answer · 2012-11-11 20:23:55Z

5

I think you are looking at the command to create new rails app with mysql configuration in database.yml

rails new app --database mysql

I hope it answers your query.

answered Nov 11, 2012 at 20:23

Icicle

1,1749 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tim · Accepted Answer · 2016-09-13 11:19:43Z

3

First of all you need to install mysql2 in your system

sudo  gem install mysql2 -v=0.2.11

Once you have installed mysql2, then you are ready to create a new app with Mysql as default

rails new sample_app -d mysql

Tim

1,9333 gold badges28 silver badges39 bronze badges

answered Sep 13, 2016 at 9:52

maulik bafalipara

2483 silver badges12 bronze badges

Shamir K. · Accepted Answer · 2012-11-11 07:30:27Z

1

If you use bundler, then you should add

gem "mysql2"

to your Gemfile and run

bundle install

and then specify your database settings in config/database.yml

answered Nov 11, 2012 at 7:30

Shamir K.

3952 silver badges7 bronze badges