Database access denied migrating rails database


#1

Hi,

I’m trying to deploy a new rails app and am having trouble with migrating the database. I have the following production settings in my database.yml:

production:
adapter: mysql
encoding: utf8
database: practice_production
username: phil
password: xxxxxx
host: mysql.philnash.co.uk

yet when I ssh into the server and call rake db:migrate I get the following error:

Access denied for user ‘phil’@‘xxx.xxx.208.0/255.255.240.0’ to database ‘practice_production’

It’s taken a bit of effort to get this far and I’m lost now. Can someone point me in the right direction so that I can migrate my database and get the app working?

Thanks in advance!