Hello. I have set a rails app, set the database.yml file, generated a simple model, created the migration class file for this model and then iÂ´m trying to run the cmd: rake migrate, but i receive the following msg: 1. C:\Documents and Settings\Ken\My Documents\RoR Projects\railslist>rake migrate 2. (in C:/Documents and Settings/Ken/My Documents/RoR Projects/railslist) 3. rake aborted! 4. #28000Access denied for user 'root'@'localhost' (using password: YES) WhatÂ´s probably happening is that MySql is denying access to Rails ... but i canÂ´t figure out how to fix it. Any ideas?
on 2007-03-08 09:51
on 2007-03-08 13:23
> What´s probably happening is that MySql is denying access to Rails ... > but i can´t figure out how to fix it. Any ideas? if you're database.yml has something like: username: root password: i.e. no password Try connecting to mysql: mysql -u root If you can't connect, you'll need to set up a user 'root' without a password. Something like from within mysql: GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION; MySQL docs: http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
on 2007-03-08 13:24
> 1. C:\Documents and Settings\Ken\My Documents\RoR > Projects\railslist>rake migrate oops. rake migrate is deprecated, instead use: rake db:migrate
on 2007-03-09 09:36
I am also having the same problem now. if u find a soln. please let me know. Mohan
on 2007-03-10 19:01
Hi all ... I created a new user and set the proper permissions to this new user and now everything works fine!