forum

Home / DeveloperSection / Forums / Create a new Ruby on Rails application using MySQL instead of SQLite

Ask Question

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

Anonymous User249128-Dec-2014
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?
ruby on railsruby on rails mysql ruby 
Updated on 29-Dec-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Manoj Bhatt

Manoj Bhatt

29-Dec-2014

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).

Liked By