Migrate fails because of whitespace after user in database.y

[I submitted this today around 5AM EST under the following

title by it never appeared on the group:“Rake db:migrate fails on
after user/pswd in database.yml”


Hi All,

I just created a model for a new application and got a db/migrate/001_

I added a couple of field definitions to the create_table statement.

I ran Rake db:migrate and got the message “access denied for user
‘root’” as
shown below.

I noted the whitespace following “root” in the error message.

I removed trailing whitespace following assigned username and password.

Problem went away!!

I have the username and password defined in my.cnf with no trailing

I’m running WinXP-Pro/SP2, Ruby 1.8.2-15, Rails 1.1.6, MySQL 5.0.27-nt.

That seems like a bug somewhere. Anybody agree?

Thanks in advance,


==== Command Window ===

C:_Projects\MyRailsDemo\MyFirstApp>rake db:migrate

(in C:/_Projects/MyRailsDemo/MyFirstApp)

rake aborted!

#28000Access denied for user 'root '@‘localhost’ (using
password: YES)

(See full trace by running task with --trace)

======== end ===========