How to connect to MYSQL database manually with Rails?

Question

I want to connect to a MySQL database without adding it to database.yml. How can I connect and run a query on that database?

I understand I need to do something like this, but what's the code for actually making the connection to the specific IP/port first?

query = "SELECT 1"
ActiveRecord::Base.connection.execute(query)

Just using ActiveRecord or through the mysql2 gem?

Sebastián Palma
– Sebastián Palma

2017-06-05 16:09:56 +00:00
Commented Jun 5, 2017 at 16:09 — Sebastián Palma
– Sebastián Palma, Commented Jun 5, 2017 at 16:09
@SebastiánPalma either works

Henley Wing Chiu
– Henley Wing Chiu

2017-06-05 17:16:09 +00:00
Commented Jun 5, 2017 at 17:16 — Henley Wing Chiu
– Henley Wing Chiu, Commented Jun 5, 2017 at 17:16

steve · Accepted Answer · 2017-06-05 16:03:06Z

4

You might want to try ActiveRecord::Base.establish_connection

Example from documentation:

ActiveRecord::Base.establish_connection(
  :adapter  => "mysql",
  :host     => "localhost",
  :username => "myuser",
  :password => "mypass",
  :database => "somedatabase"
)

From:

https://apidock.com/rails/ActiveRecord/Base/establish_connection/class

answered Jun 5, 2017 at 16:03

steve

3713 silver badges12 bronze badges

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

2 Comments

Henley Wing Chiu Over a year ago

set conn = to that. Then conn.execute(query) ?

steve Over a year ago

My guess is that you need to use the code above first on its own, and then you can use ActiveRecord::Base.connection as you did in the question. Does that work?

Collectives™ on Stack Overflow

How to connect to MYSQL database manually with Rails?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related