Richard Lionheart
2007-Feb-01 23:11 UTC
Migrate fails because of whitespace after user in database.yml
[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 ========== --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---