ccess denied for user 'root'@'localhost' (using password: NO)

Hi,

I already have the password set in database.yml but I am still getting this error in the development.log

/!\ FAILSAFE /!\ Thu Dec 24 11:50:28 +0800 2009   Status: 500 Internal Server Error   Access denied for user 'root'@'localhost' (using password: NO)     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/mysql_adapter.rb:589:in `real_connect'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/mysql_adapter.rb:589:in `connect'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/mysql_adapter.rb:203:in `initialize'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/mysql_adapter.rb:75:in `new'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/mysql_adapter.rb:75:in `mysql_connection'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:223:in `send'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:223:in `new_connection'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:245:in `checkout_new_connection'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:188:in `checkout'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:184:in `loop'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:184:in `checkout'     /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:183:in `checkout'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:98:in `connection'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:326:in `retrieve_connection'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_specification.rb:123:in `retrieve_connection'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_specification.rb:115:in `connection'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ query_cache.rb:9:in `cache'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ query_cache.rb:28:in `call'     /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ connection_adapters/abstract/connection_pool.rb:361:in `call'     /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ string_coercion.rb:25:in `call'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/head.rb:9:in `call'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/methodoverride.rb: 24:in `call'     /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ params_parser.rb:15:in `call'     /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ session/cookie_store.rb:93:in `call'     /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ failsafe.rb:26:in `call'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `synchronize'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in `call'     /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ dispatcher.rb:114:in `call'     /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ reloader.rb:34:in `run'     /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/ dispatcher.rb:108:in `call'     /usr/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/rails/rack/static.rb: 31:in `call'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:46:in `call'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `each'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in `call'     /usr/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/rails/rack/ log_tailer.rb:17:in `call'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/content_length.rb: 13:in `call'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/handler/webrick.rb: 50:in `service'     /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'     /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'     /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'     /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'     /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'     /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'     /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'     /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'     /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'     /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'     /usr/lib/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/handler/webrick.rb: 14:in `run'     /usr/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/commands/server.rb:111     /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'     /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'     script/server:3

I did not find any similar errors by googling. Is there something wrong with my other files?

D

Can you paste your database.yml file? What is the RAILS_ENV variable set to?

Cheers!

Thanks for pointing the RAILS_ENV. Earlier, I set it to production where in fact it should be on development.