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 http://stackoverflow.com/questions/5366934/help-setting-up-ruby-on-rails-and-mysql-reward-offered — Thai Tran, Nov 11 '12 at 07:25

score 5 · Answer 1 · answered Nov 11 '12 at 20:23

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 '12 at 20:23

Icicle

score 3 · Answer 2 · edited Sep 13 '16 at 11:19

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

edited Sep 13 '16 at 11:19

Tim

answered Sep 13 '16 at 09:52

maulik bafalipara

score 1 · Answer 3 · answered Nov 11 '12 at 07:30

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 '12 at 07:30

Shamir K.

3 Answers3