Database access denied migrating rails database
Posted by: philnash
Posted on: 2008-11-17 16:07:00
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!