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

Question

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!

score 0 · Answer 1 · answered Mar 09 '17 at 13:06

0

I know this is old, but what you need to do is to set default_env in your deploy.rb file and set environment variables.

Something like this:

set :default_env, { 
  'var1' => 'value1',
  'var2' => 'value2'
}

This will work for Capistrano 3. Hope this will help anyone stumbling upon this question.

answered Mar 09 '17 at 13:06

Jeremie

1,852
1
13
24

Could you give it a try? – Jeremie Mar 11 '17 at 15:37
I have issues with this solution... How is this secure? – Erick Maynard Apr 04 '18 at 22:38
@ErickMaynard What issues do you have? – Jeremie Apr 04 '18 at 23:21

score 0 · Answer 2 · answered Mar 22 '11 at 12:33

You might've already been through this, but I'd suggest you double check that your config/environments/production.yml contains valid credentials and is pushed into the repository.

You mentioned you have tried to do the migration manually on the server. Did you run the migration from the very same directory, where your current deployed app lies ?

(/home/hy/work/log/current)

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

2 Answers2