Question

How do I connect my Rails app to use MySQL on my digital Ocean droplet?

Hi, my Ruby on Rails demo app runs well with Sqlite. I now need to use MySQL database created on my droplet. Ho would I do this. I would appreciate your support Pierre


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Generally, in order to use MySql for a Rails app there are a few steps that need to be followed. First, install MySql itself:

sudo apt-get install mysql-server

You’ll also want to create a separate user and database for your app. This tutorial will walk you through creating users in MySql:

Next, require the mysql gem in your app’s Gemfile and re-run bundle install in order to install it.

Then in your config/database.yml file, you’ll need to set the correct information for your app to be able to connect to the database. It would look something like this:

production:
  adapter: mysql
  encoding: utf8
  database: rails_app
  username: rails_user
  password: pwd
  host: 127.0.0.1
  port: 3306
  pool: 10

Hopefully, this points you in the right direction. Let us know how it goes!