Intel Mac, Rails, MYSQL - access denied

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

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 P. [email protected] wrote:

rake aborted!
jp


Posted via http://www.ruby-forum.com/.


Rails mailing list
[email protected]
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 S. 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 P. [email protected] wrote:

rake aborted!
jp


Posted via http://www.ruby-forum.com/.


Rails mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails


http://www.robsanheim.com
http://www.seekingalpha.com
http://www.ajaxian.com