# Intel Mac, Rails, MYSQL - access denied

**URL:** <https://www.ruby-forum.com/t/intel-mac-rails-mysql-access-denied/98270>\
**Category:** Rails\
**Created:** [July 13, 2006, 4:56pm UTC](https://www.ruby-forum.com/t/intel-mac-rails-mysql-access-denied/98270 "2006-07-13T16:56:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeffpritchard](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/43a26b/32.png) [@jeffpritchard](https://www.ruby-forum.com/u/jeffpritchard)\
**Post date:** [July 13, 2006, 4:56pm UTC](https://www.ruby-forum.com/t/intel-mac-rails-mysql-access-denied/98270/1 "2006-07-13T16:56:05Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jeffpritchard](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/43a26b/32.png) [@jeffpritchard](https://www.ruby-forum.com/u/jeffpritchard)\
**Post date:** [July 13, 2006, 5:03pm UTC](https://www.ruby-forum.com/t/intel-mac-rails-mysql-access-denied/98270/2 "2006-07-13T17:03:49Z")

</div>

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. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> rake aborted!  
> jp
> 
> –  
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> 
> * * *
> 
> Rails mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

–

> **[Home](https://robsanheim.com/)**
>
> Just another WordPress site

> **[Seeking Alpha | Stock Market Analysis & Tools for Investors](https://seekingalpha.com/)**
>
> Join Seeking Alpha, the largest investing community in the world. Get stock market news and analysis, investing ideas, earnings calls, charts and portfolio analysis tools.

> **[Purchase Intent Data for Enterprise Tech Sales and Marketing | TechTarget](https://www.techtarget.com/)**
>
> Identify, influence and engage active buyers in your tech market with TechTarget's purchase intent insight-powered solutions. Activity matters.

---

<div class="post-metadata">

**Author:** ![jeffpritchard](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/43a26b/32.png) [@jeffpritchard](https://www.ruby-forum.com/u/jeffpritchard)\
**Post date:** [July 14, 2006, 1:01am UTC](https://www.ruby-forum.com/t/intel-mac-rails-mysql-access-denied/98270/3 "2006-07-14T01:01:35Z")

</div>

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. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > rake aborted!  
> > jp
> > 
> > –  
> > Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> > 
> > * * *
> > 
> > Rails mailing list  
> > removed\_email\_address@domain.invalid  
> > [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)
> 
> –  
> [http://www.robsanheim.com](http://www.robsanheim.com)  
> [http://www.seekingalpha.com](http://www.seekingalpha.com)  
> [http://www.ajaxian.com](http://www.ajaxian.com)