---
title: "Create a new Ruby on Rails application using MySQL instead of SQLite"  
description: "Create a new Ruby on Rails application using MySQL instead of SQLite"  
author: "Anonymous User"  
published: 2014-12-28  
updated: 2014-12-29  
canonical: https://www.mindstick.com/forum/12824/create-a-new-ruby-on-rails-application-using-mysql-instead-of-sqlite  
category: "ruby on rails"  
tags: ["ruby on rails", "mysql", "ruby"]  
reading_time: 1 minute  

---

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

I want to create my [Rails](https://www.mindstick.com/forum/12821/implementation-of-remember-me-in-a-rails-application) [application](https://www.mindstick.com/articles/12824/calculator-application-in-android) with [MySQL](https://www.mindstick.com/articles/12156/what-is-mysql), because I like it so much. How can I do that in the [latest version](https://www.mindstick.com/forum/159157/what-is-the-latest-version-of-c-sharp) of Rails [instead of](https://www.mindstick.com/articles/330/triggers-in-sql-server) the [default](https://www.mindstick.com/interview/12771/what-is-the-importance-of-default-resources) [SQLite](https://www.mindstick.com/articles/1554/crud-operation-in-asp-dot-net-using-sqlite-database)?

## Replies

### Reply by Manoj Bhatt

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


---

Original Source: https://www.mindstick.com/forum/12824/create-a-new-ruby-on-rails-application-using-mysql-instead-of-sqlite

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.