Create a new Ruby on Rails application using MySQL instead of SQLite

Question

I want to create my Rails application with MySQL, because I like it so much. How can I do that in the latest version of Rails instead of the default SQLite?

score 270 · Answer 1 · edited Aug 10 '12 at 00:45

270

Normally, you would create a new Rails app using

rails ProjectName

To use MySQL, use

rails new ProjectName -d mysql

edited Aug 10 '12 at 00:45

RubyBeginner

319
1
5
14

answered Aug 06 '08 at 15:52

Daniel Broekman

4,511
3
21
14

Michiel de Mare · Accepted Answer · 2014-01-07T10:59:29.450

143

If you already have a rails project, change the adapter in the config/database.yml file to mysql and make sure you specify a valid username and password, and optionally, a socket:

development:
  adapter: mysql2
  database: db_name_dev
  username: koploper
  password:
  host: localhost
  socket: /tmp/mysql.sock

Next, make sure you edit your Gemfile to include the mysql2 or activerecord-jdbcmysql-adapter (if using jruby).

edited Jan 07 '14 at 10:59

answered Aug 06 '08 at 16:04

Michiel de Mare

41,982
29
103
134

2

This is helpful; as the other answers just use the generator. This answer works for adding MySQL to an app after it's already been created, either to replace an existing (e.g. SQLite) DB or to add a secondary database. Also, mysql2 seems to be the go-to gem these days for Rails. – rcd Jan 05 '14 at 21:27
14

you'll also have to update the Gemfile; remove `gem 'sqlite3'` and add `gem 'mysql2'` – raddrick Jan 23 '14 at 15:05

score 62 · Answer 3 · edited Oct 20 '18 at 14:00

62

For Rails 3 you can use this command to create a new project using mysql:

$ rails new projectname -d mysql

edited Oct 20 '18 at 14:00

MEE

503
1
11
21

answered Dec 14 '10 at 11:08

Robbie Done

1,157
9
22

score 25 · Answer 4 · edited Jul 17 '13 at 18:23

25

Go to the terminal and write:

rails new <project_name> -d mysql

edited Jul 17 '13 at 18:23

Anil

2,430
3
37
55

answered Jan 21 '13 at 11:55

Abhinav

251
3
2

score 22 · Answer 5 · answered Jun 23 '14 at 11:47

If you have not created your app yet, just go to cmd(for windows) or terminal(for linux/unix) and type the following command to create a rails application with mysql database:

$rails new <your_app_name> -d mysql

It works for anything above rails version 3. If you have already created your app, then you can do one of the 2 following things:

Create a another_name app with mysql database, go to cd another_name/config/ and copy the database.yml file from this new app. Paste it into the database.yml of your_app_name app. But ensure to change the database names and set username/password of your database accordingly in the database.yml file after doing so.

OR

Go to cd your_app_name/config/ and open database.yml. Rename as following:

development:
adapter: mysql2
database: db_name_name
username: root
password:
host: localhost
socket: /tmp/mysql.sock

Moreover, remove gem 'sqlite3' from your Gemfile and add the gem 'mysql2'

score 13 · Answer 6 · edited May 10 '12 at 08:43

13

If you are using rails 3 or greater version

rails new your_project_name -d mysql

if you have earlier version

rails new -d mysql your_project_name

So before you create your project you need to find the rails version. that you can find by

rails -v

edited May 10 '12 at 08:43

Andrea

839
8
21

answered Aug 04 '11 at 04:15

Coder

1,917
3
17
33

score 12 · Answer 7 · answered Apr 27 '09 at 06:28

12

rails -d mysql ProjectName

answered Apr 27 '09 at 06:28

huacnlee

430
3
9

score 11 · Answer 8 · edited Jun 21 '12 at 14:17

11

rails new <project_name> -d mysql

OR

rails new projectname

Changes in config/database.yml

development:
  adapter: mysql2
  database: db_name_name
  username: root
  password:
  host: localhost
  socket: /tmp/mysql.sock

edited Jun 21 '12 at 14:17

moribvndvs

42,191
11
135
149

answered Jun 21 '12 at 12:30

vijay chouhan

1,012
8
25

score 11 · Answer 9 · answered Jan 21 '13 at 13:49

11

Create application with -d option

rails new AppName -d mysql

answered Jan 21 '13 at 13:49

Dipali Nagrale

510
5
17

score 9 · Answer 10 · edited Nov 18 '11 at 15:05

9

$ rails --help

is always your best friend

usage:

$ rails new APP_PATH[options]

also note that options should be given after the application name

rails and mysql

$ rails new project_name -d mysql

rails and postgresql

$ rails new project_name -d postgresql

edited Nov 18 '11 at 15:05

Brandon

68,708
30
194
223

answered Nov 18 '11 at 14:26

George Bellos

184
2
4

score 9 · Answer 11 · answered Mar 29 '12 at 08:32

You should use the switch -D instead of -d because it will generate two apps and mysql with no documentation folders.

  rails -D mysql project_name  (less than version 3)

  rails new project_name -D mysql (version 3 and up)

Alternatively you just use the --database option.

score 6 · Answer 12 · edited May 10 '12 at 08:44

6

If you are creating a new rails application you can set the database using the -d switch like this:

rails -d mysql myapp

Its always easy to switch your database later though, and using sqlite really is easier if you are developing on a Mac.

edited May 10 '12 at 08:44

Sathyajith Bhat

21,321
22
95
134

answered Aug 06 '08 at 15:53

James Avery

3,062
1
20
26

score 6 · Answer 13 · edited Mar 14 '17 at 06:49

6

Just go to rails console and type:

rails new YOURAPPNAME -d mysql

edited Mar 14 '17 at 06:49

Pang

9,564
146
81
122

answered Feb 15 '17 at 07:32

Amarpreet Jethra

141
1
11

score 6 · Answer 14 · edited May 10 '12 at 08:42

6

In Rails 3, you could do

$rails new projectname --database=mysql

edited May 10 '12 at 08:42

Sathyajith Bhat

21,321
22
95
134

answered May 18 '11 at 15:09

andy318

542
4
8

score 4 · Answer 15 · answered Feb 08 '18 at 21:45

On new project, easy peasy:

rails new your_new_project_name -d mysql

On existing project, definitely trickier. This has given me a number of issues on existing rails projects. This kind of works with me:

# On Gemfile:
gem 'mysql2',  '>= 0.3.18', '< 0.5' # copied from a new project for rails 5.1 :)
gem 'activerecord-mysql-adapter' # needed for mysql..

# On Dockerfile or on CLI:
sudo apt-get install -y  mysql-client libmysqlclient-dev

score 2 · Answer 16 · edited Jan 14 '18 at 14:48

2

First make sure that mysql gem is installed, if not? than type following command in your console

gem install mysql2

Than create new rails app and set mysql database as default database by typing following command in your console

rails new app-name -d mysql

edited Jan 14 '18 at 14:48

CodeIt

3,492
3
26
37

answered Sep 20 '17 at 12:45

Shabbir

29
7

1

you want to add the gem to Gemfile instead. – Riccardo Feb 08 '18 at 21:42

score 0 · Answer 17 · answered Sep 01 '18 at 18:58

0

Use following command to create new app for API with mysql database

rails new <appname> --api -d mysql


  adapter: mysql2
  encoding: utf8
  pool: 5
  username: root
  password: 
  socket: /var/run/mysqld/mysqld.sock

answered Sep 01 '18 at 18:58

Dinesh Vaitage

2,983
19
16

score 0 · Answer 18 · answered Feb 22 '19 at 05:02

database.yml

# MySQL. Versions 5.1.10 and up are supported.
#
# Install the MySQL driver
#   gem install mysql2
#
# Ensure the MySQL gem is defined in your Gemfile
#   gem 'mysql2'
#
# And be sure to use new-style password hashing:
#   https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
#
default: &default
  adapter: mysql2
  encoding: utf8
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  host: localhost
  database: database_name
  username: username
  password: secret

development:
  <<: *default

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  <<: *default

# As with config/secrets.yml, you never want to store sensitive information,
# like your database password, in your source code. If your source code is
# ever seen by anyone, they now have access to your database.
#
# Instead, provide the password as a unix environment variable when you boot
# the app. Read http://guides.rubyonrails.org/configuring.html#configuring-a-database
# for a full rundown on how to provide these environment variables in a
# production deployment.
#
# On Heroku and other platform providers, you may have a full connection URL
# available as an environment variable. For example:
#
#   DATABASE_URL="mysql2://myuser:mypass@localhost/somedatabase"
#
# You can use this database configuration with:
#
#   production:
#     url: <%= ENV['DATABASE_URL'] %>
#
production:
  <<: *default

Gemfile:

# Use mysql as the database for Active Record
gem 'mysql2', '>= 0.4.4', '< 0.6.0'

score 0 · Answer 19 · answered Apr 08 '20 at 17:55

you first should make sure that MySQL driver is on your system if not run this on your terminal if you are using Ubuntu or any Debian distro

sudo apt-get install mysql-client libmysqlclient-dev

and add this to your Gemfile

gem 'mysql2', '~> 0.3.16'

then run in your root directory of the project

bundle install

after that you can add the mysql config to config/database.yml as the previous answers

Create a new Ruby on Rails application using MySQL instead of SQLite

19 Answers19

Linked