Can't connect to remote mysql db with rails

Question

I'm having trouble connecting to a remote mysql db with mysql2 gem.

I get this error:

Host 'my_ip' is not allowed to connect to this MySQL server

My db.yml says:

remote_development:
  adapter: mysql2
  reconnect: false
  host: host_ip
  encoding: utf8
  database: host_db
  pool: 5
  username: root
  password:

And when I try to connect via my sql or telnet I have no problems at all. I've double and triple checked the data con my yml, but can't get through this. Any idea?

Btw I'm using Rails 3.2.3, Ruby 1.9.3, and tried mysql2 v 0.2.18 and 0.3.11 ... pls HELP!

Are you sure that, you're giving the right password? and make sure you've a space(" ") between key and value. For example: password: my_password instead of password:my_password. — Surya
– Surya, Commented May 19, 2012 at 6:02

Rahul · Accepted Answer · 2014-09-16 12:46:37Z

2

I solved this, pretty simple...

I just created a new user and password to the db with specific permissions instead of using root :)

Should have tried this from the beginning. I think this is the correct approach.

edited Sep 16, 2014 at 12:46

Rahul

47.4k27 gold badges76 silver badges103 bronze badges

answered Jun 8, 2012 at 15:04

Frannito

751 silver badge12 bronze badges

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

Comments

sneakerfish · Accepted Answer · 2012-05-21 17:58:52Z

0

This seems to be a MySQL error message. I think the problem may be the user account that you are using. It should be set up with the 'username'@'%' format when setting it up. The percent sign means all ip addresses. You should then flush privileges on the server to make the account available.

answered May 21, 2012 at 17:58

sneakerfish

262 bronze badges

1 Comment

Frannito Over a year ago

I did that :c. I can't access without problems from a mysql console. It's rails where the mistake is, but I don't know if it is my mistake or some gem incompatibility

manikandan · Accepted Answer · 2012-05-30 05:10:10Z

0

development:

adapter: mysql2

encoding: utf8

reconnect: false

database: mystore_development

pool: 5

username: root

password:password

host: localhost

try this one surely it wil work...

answered May 30, 2012 at 5:10

manikandan

988 bronze badges

3 Comments

manikandan Over a year ago

some times they use tab instead of space please check that also

manikandan Over a year ago

create database mystore_development in your db

Frannito Over a year ago

How this differ of what I'm doing now? Besides setting the host to local. I have no problems with local db, my issue is with remote conections.

Botz3000 · Accepted Answer · 2012-05-29 19:13:38Z

-1

change your host:localhost and try it again it will work

edited May 29, 2012 at 19:13

Botz3000

39.8k8 gold badges107 silver badges128 bronze badges

answered May 29, 2012 at 12:49

manikandan

988 bronze badges

1 Comment

Frannito Over a year ago

but the db I'm trying to use is on another server

Collectives™ on Stack Overflow

Can't connect to remote mysql db with rails

4 Answers 4

Comments

1 Comment

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related