I have asked a question similar, but not same. I was unable to connect
to my
remote mysql server from windows, it tries to connect to local server,
whatever i wrote in database.yml din’t made any changes at all. So i ve
switched to linux. Now my rails app sees what i wrote inside my
database.yml
and tries to connect the right ip address. But now my rake tool gets
confused and tries to connect local mysql instance.
I think i have to override database.yml file for rake only, but i don’t
know
how to do so.
— database.yml (i ve changed my host with *)
development:
adapter: mysql2
encoding: utf8
reconnect: false
database: devel_database
pool: 5
username: 'username'
password: 'password'
host: *.*.*.*
test:
adapter: mysql2
encoding: utf8
reconnect: false
database: temp_test
pool: 5
username: root
password:
host: *.*.*.*
production:
adapter: mysql2
encoding: utf8
reconnect: false
database: temp_production
pool: 5
username: root
password:
host: *.*.*.*
— database.yml
gkaykck@node2:~/Dropbox/portalegitim$ rake db:migrate
(in /home/gkaykck/Dropbox/portalegitim)
rake aborted!
Access denied for user 'username'@'78.170.46.170' (using password:
YES)
(See full trace by running task with --trace)
78.170.46.170 is my computers ip not my mysql servers ip. It is
different in
database.yml file