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

mysql ruby-on-rails ruby
Daniel Broekman picture Daniel Broekman · Aug 6, 2008 · Viewed 147.3k times · Source

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?

Answer

Daniel Broekman picture Daniel Broekman · Aug 6, 2008

Normally, you would create a new Rails app using

rails ProjectName

To use MySQL, use

rails new ProjectName -d mysql

Related questions

Error installing mysql2: Failed to build gem native extension

I am having some problems when trying to install mysql2 gem for Rails. When I try to install it by running bundle install or gem install mysql2 it gives me the following error: Error installing mysql2: ERROR: Failed to build …

Read More
Change a column type from Date to DateTime during ROR migration

I need to change my column type from date to datetime for an app I am making. I don't care about the data as its still being developed. How can I do this?

Read More
Correct MySQL configuration for Ruby on Rails Database.yml file

I have this configuration: development: adapter: mysql2 encoding: utf8 database: my_db_name username: root password: my_password host: mysql://127.0.0.1:3306 And I am getting this error: Unknown MySQL server host 'mysql://127.0.0.1:3306' (1) Is there something obvious that I am doing …

Read More