Hi, Nuby on Rails here trying to bring up an existing app on a new installation. The whole ruby/rails/mysql/lighty installation was done per the much touted "hivelogic article" that runs through all the steps. I am running into a permission error when I try to do a rake migrate to set up a session database needed by this existing app. Extracted from the trace... ** Execute db:migrate rake aborted! Access denied for user ''root''@''localhost'' (using password: YES) I am able to "mysql -u root " and get into mysql and do things. I''ve tried granting all to root at localhost. No complaints about that from mysql, but restarted it and tried the rake again, same thing. Any ideas on what setup I still need to do to give rake the access it needs to the database? thanks, jp -- Posted via http://www.ruby-forum.com/.
Try: running script/console, and see if it connects. Paste the output if it doesn''t. Also, what does your database.yml have? - rob On 7/13/06, Jeff Pritchard <jp@jeffpritchard.com> wrote:> Hi, > Nuby on Rails here trying to bring up an existing app on a new > installation. > The whole ruby/rails/mysql/lighty installation was done per the much > touted "hivelogic article" that runs through all the steps. > > I am running into a permission error when I try to do a rake migrate to > set up a session database needed by this existing app. Extracted from > the trace... > ** Execute db:migrate > rake aborted! > Access denied for user ''root''@''localhost'' (using password: YES) > > I am able to "mysql -u root " and get into mysql and do things. > I''ve tried granting all to root at localhost. No complaints about that > from mysql, but restarted it and tried the rake again, same thing. > > Any ideas on what setup I still need to do to give rake the access it > needs to the database? > > thanks, > jp > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- http://www.robsanheim.com http://www.seekingalpha.com http://www.ajaxian.com
Thanks for the help, but it turns out it was my brain that was disconnected. I''m not used to the three different environments for Rails yet. In my universe there should just be two, test, or temp, and the real one. Somehow my brain focused on the test environment when what I obviously needed to look at was the development. Anyway, once I focused on the right environment, everything fell into place, and I''m running on all three cylinders again. thanks, jp Rob Sanheim wrote:> Try: > > running script/console, and see if it connects. Paste the output if it > doesn''t. > > Also, what does your database.yml have? > > - rob > > On 7/13/06, Jeff Pritchard <jp@jeffpritchard.com> wrote: >> rake aborted! >> jp >> >> -- >> Posted via http://www.ruby-forum.com/. >> _______________________________________________ >> Rails mailing list >> Rails@lists.rubyonrails.org >> http://lists.rubyonrails.org/mailman/listinfo/rails >> > > > -- > http://www.robsanheim.com > http://www.seekingalpha.com > http://www.ajaxian.com-- Posted via http://www.ruby-forum.com/.