RoR DB Migration Access Denied error

[schwecheimer]

I am getting an access denied error when I am trying to run my database migrations. any ideas? I have all my users setup correctly and my database.yml file is also setup correctly.

Here's my trace information:

** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
Access denied for user 'USER'@'localhost' (using password: YES)
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mys
ql_adapter.rb:330:in `real_connect'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mys
ql_adapter.rb:330:in `connect'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mys
ql_adapter.rb:87:in `initialize'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mys
ql_adapter.rb:36:in `new'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mys
ql_adapter.rb:36:in `mysql_connection'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abs
tract/connection_specification.rb:251:in `send'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abs
tract/connection_specification.rb:251:in `connection_without_query_cache='
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/query_cache.rb:54:in `c
onnection='
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abs
tract/connection_specification.rb:220:in `retrieve_connection'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abs
tract/connection_specification.rb:78:in `connection'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:282:in `mi
grate'
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/tasks/databases.rake:4
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `call'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:357:in `invoke'
/usr/lib/ruby/1.8/thread.rb:135:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in `invoke'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/bin/rake:7
/usr/bin/rake:18:in `load'
/usr/bin/rake:18

[cade]

Based on the error message that you have included, it looks like you have not defined the username and password for the database in the database.yml file.

>Access denied for user 'USER'@'localhost' (using password: YES)

This suggests that rails is trying to log into the database with the wrong credentials. If that isn't the case, post your database.yml file so that we can take a look at it.

[schwecheimer]

I fixed my problem. When I updated the environment.rb file the application got sent back into development mode. LOL hence why my SQL connection didn't work.

[prajkta]

I fixed my problem. When I updated the environment.rb file the application got sent back into development mode. LOL hence why my SQL connection didn't work.
Hi schwecheimer,

M getting the same problem
" Mysql::Error in UsersController#index

Access denied for user 'prajkta'@'localhost' (using password: YES)"

Can u please tell me what changes u made in environment.rb that fixed your problem?


Thanks,
Prajkta