Why would rake migrate not use password to connect to DB?

Hey all,

I’m having a weird rake db:migrate issue on my hosting server

I’ve updated my database.yml with the info for all of my DB

I’ve created the databases and can log in directly using mysql from the
command line.

Yet, when I run rake db:migrate RAILS_ENV=production, I get this:
rake aborted!
Access denied for user ‘bblastdbqa’@‘localhost’ (using password: NO)

It’s picked up the right user from my database.yml, but I don’t
understand why rake is trying to log in to MySQL without a password.
The password value is present in /config/database.yml.

I can run this command without a problem:
rake db:migrate RAILS_ENV=development

I’ve also killed off the Ruby processes on the server and restarted
lighttpd after updating database.yml.

So, I’m tearing my hair out a bit. :slight_smile:

Anyone have any ideas or next things to try? Any help is definitely


To close this issue, it was a pretty simple mistake. The database
password begin with a pound sign (#)…so in the database.yml file, it
looked like a comment. So it looked like there was no password. So rake
was trying to log in without a password.

(sigh) One of those days…