capistrano deploy: Access denied for user 'root'@'localhost' (using password: YES) (Mysql::Error)

Question

hi,

I tried to deploy ror application on production server then got this error:

Access denied for user 'root'@'localhost' (using password: YES) (Mysql::Error)

but when i ran command:

rake db:migrate RAILS_ENV=production

it passed. I also connect to mysql from command line:

mysql -u root -p 

it got through, and i can see all the tables are created.

i m working on a branch , in my deploy.rb i already set the branch:

set :branch 'myBranch'

and in apache2 configuration file, i set rails_env too:

<VirtualHost *:80>
  ServerName daemon.com
  DocumentRoot /home/hy/work/log/current/public/
  RailsEnv production
</VirtualHost>

Please help, thanks!