How to access mysql database from one server to another server

Question

I am new Ruby on Rails. I need to access mysql database of one server (For example, xxx.xxx.xx) to another server (xxx.xxx.xx) in ruby on rails. is this possible in ruby script? Can you anybody guide me?

You mean you have a remote db?

Rahul
– Rahul

2012-02-06 17:38:53 +00:00
Commented Feb 6, 2012 at 17:38 — Rahul
– Rahul, Commented Feb 6, 2012 at 17:38

nkm · Accepted Answer · 2012-02-06 17:47:23Z

1

You just need to mention host and port in your database.yml file.

production:
  adapter: mysql
  database: databasename
  username: username
  password: password
  host: xx.xx.xx.xx
  port: 3306

answered Feb 6, 2012 at 17:47

nkm

5,9142 gold badges27 silver badges39 bronze badges

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

2 Comments

Anandh L.v Over a year ago

Thanks. I need another clarification. i have rake task for importing images using remote_url with the help of paperclip plugin. created photos folder under rails project folder if i run that rake on localhost server. is it possible to put all images in the new server.

nkm Over a year ago

I guess it should, but am not sure. Try to figure it out from google search, if you could not found any solution ask a new question. There should be somebody who might faced the same issue and could help you out.

Collectives™ on Stack Overflow

How to access mysql database from one server to another server

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