[I submitted this today around 5AM EST under the following
title by it never appeared on the group:"Rake db:migrate fails on whitespace after user/pswd in database.yml"
]
Hi All,
I just created a model for a new application and got a db/migrate/001_ ...file.
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 whitespace
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,
Richard
==== 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 ===========