Forum: Ruby on Rails Migrate fails because of whitespace after user in database.y

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
31fdda5f38fc6df4e193cfb7445ddc5a?d=identicon&s=25 Richard Lionheart (Guest)
on 2007-02-02 00:12
(Received via mailing list)
[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 ===========
This topic is locked and can not be replied to.