Connecting Rails 4 with remote MySQL database

Question

I have been working with Rails since two months but until now I haven't use databases.

I would like that my web-app connects to a remote database (MySQL) and extract some data to plot it in Rails using Highcharts.

I have found many tutorials that explains how to connect to an existing database (editing config/database.yml) but this is in the same server.

I am using Ubuntu 14.04 LTS.

Could anyone explains me which are the steps or how can achieve this connection to the remote database with Rails and how to extract the data from a given database?

osman · Accepted Answer · 2015-07-01 16:20:49Z

6

You just edit the database.yml file so that it points to the remote database:

  adapter: mysql2
  encoding: utf-8
  pool: 5
  username: "username"
  password: "password"
  host: "hostname"
  port: "port number"
  database: "database name"

edited Jul 1, 2015 at 16:20

answered Jul 1, 2015 at 6:27

osman

2,47719 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

karlihnos Over a year ago

But for that should I install the gem 'mysql2' in my computer?

osman Over a year ago

yeah add it to your gemfile gem 'mysql2'

karlihnos · Accepted Answer · 2015-07-02 11:17:10Z

-2

After two days asking in forums and people, nobody could help me, however, I found a solution.

IMPORTANT: To connect to an external database you should first create the SSH tunnel!!!!
Configure the database.yml

answered Jul 2, 2015 at 11:17

karlihnos

4251 gold badge7 silver badges24 bronze badges

1 Comment

lacostenycoder Over a year ago

any advice or links on how to do that?

Collectives™ on Stack Overflow

Connecting Rails 4 with remote MySQL database

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related