# Mysql + Snow Leopard + Rails **URL:** \ **Category:** Rails\ **Created:** [October 4, 2009, 11:46am UTC](https://www.ruby-forum.com/t/mysql-snow-leopard-rails/176663 "2009-10-04T11:46:07Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![tspore](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a183cd/32.png) [@tspore](https://www.ruby-forum.com/u/tspore)\ **Post date:** [October 4, 2009, 11:46am UTC](https://www.ruby-forum.com/t/mysql-snow-leopard-rails/176663/1 "2009-10-04T11:46:07Z")
I am very interested to start playing with rails, but I have now spent a whole day trying to get it all working. Which is quite disheartening. My latest issues is from within ruby when I try to connect to the DB it says: “rake aborted! Access denied for user” But: 1. I use the same connection settings to log into mysql, so I don’t see how that is. 2. Does it mean that I don’t have something pointed correctly? Can some one help? \*\* Invoke db:migrate (first\_time) \*\* Invoke environment (first\_time) \*\* Execute environment \*\* Execute db:migrate rake aborted! Access denied for user ‘root’@‘localhost’ (using password: YES) /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ connection\_adapters/mysql\_adapter.rb:585:in `real_connect' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active_record/ connection_adapters/mysql_adapter.rb:585:in`connect’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ connection\_adapters/mysql\_adapter.rb:199:in `initialize' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active_record/ connection_adapters/mysql_adapter.rb:71:in`new’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ connection\_adapters/mysql\_adapter.rb:71:in `mysql_connection' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active_record/ connection_adapters/abstract/connection_pool.rb:223:in`send’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ connection\_adapters/abstract/connection\_pool.rb:223:in `new_connection' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active_record/ connection_adapters/abstract/connection_pool.rb:245:in`checkout\_new\_connection’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ connection\_adapters/abstract/connection\_pool.rb:188:in `checkout' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active_record/ connection_adapters/abstract/connection_pool.rb:184:in`loop’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ connection\_adapters/abstract/connection\_pool.rb:184:in `checkout' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ 1.8/monitor.rb:242:in`synchronize’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ connection\_adapters/abstract/connection\_pool.rb:183:in `checkout' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active_record/ connection_adapters/abstract/connection_pool.rb:98:in`connection’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ connection\_adapters/abstract/connection\_pool.rb:326:in `retrieve_connection' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active_record/ connection_adapters/abstract/connection_specification.rb:123:in`retrieve\_connection’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ connection\_adapters/abstract/connection\_specification.rb:115:in `connection' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active_record/ migration.rb:435:in`initialize’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ migration.rb:400:in `new' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active_record/ migration.rb:400:in`up’ /Library/Ruby/Gems/1.8/gems/activerecord-2.3.4/lib/active\_record/ migration.rb:383:in `migrate' /Library/Ruby/Gems/1.8/gems/rails-2.3.4/lib/tasks/databases.rake:116 /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in`call’ /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `execute' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in`each’ /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `execute' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:578:in`invoke\_with\_call\_chain’ /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ 1.8/monitor.rb:242:in `synchronize' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in`invoke\_with\_call\_chain’ /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:564:in `invoke' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:2019:in`invoke\_task’ /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_level' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in`each’ /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_level' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in`standard\_exception\_handling’ /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:1991:in `top_level' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:1970:in`run’ /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in `standard_exception_handling' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/lib/rake.rb:1967:in`run’ /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/rake-0.8.3/bin/rake:31 /usr/bin/rake:19:in `load’ /usr/bin/rake:19 tony-spores-macbook-pro-2:music\_libary tonywork$ ---
**Author:** ![tspore](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a183cd/32.png) [@tspore](https://www.ruby-forum.com/u/tspore)\ **Post date:** [October 4, 2009, 11:49am UTC](https://www.ruby-forum.com/t/mysql-snow-leopard-rails/176663/2 "2009-10-04T11:49:03Z")
This error is simple. Your database config file is incorrect. Make sure you have the right password there. you can always try in command line ‘mysql -u root -p’ press enter and type in the password. If it works, it is correct. Trausti ---
**Author:** ![tspore](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a183cd/32.png) [@tspore](https://www.ruby-forum.com/u/tspore)\ **Post date:** [October 4, 2009, 10:07pm UTC](https://www.ruby-forum.com/t/mysql-snow-leopard-rails/176663/3 "2009-10-04T22:07:43Z")
Correct, I can connect to mysql with no issues, either via terminal, or using any php app to connect to my localhost. But I fixed it today - I need to put single quotes around the ‘password’ . I don’t know if its because I have a Symbol in the password or not, but that was the solution. My username doesn’t have the sing quotes. Thanks for the help, I began to think that because I was on Snow leopard, I didn’t upgrade correctly or something. Teaches me to do a Google search before thinking through the issue. -Tony On Oct 4, 2:47 am, Trausti Thor J. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) ---
**Author:** ![tspore](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a183cd/32.png) [@tspore](https://www.ruby-forum.com/u/tspore)\ **Post date:** [October 5, 2009, 10:27am UTC](https://www.ruby-forum.com/t/mysql-snow-leopard-rails/176663/4 "2009-10-05T10:27:34Z")
Most probably your symbol in the password led to invalid yaml code (without the quotes) just dropping half of the password… Andi ---
**Author:** ![tspore](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/a183cd/32.png) [@tspore](https://www.ruby-forum.com/u/tspore)\ **Post date:** [October 5, 2009, 2:00pm UTC](https://www.ruby-forum.com/t/mysql-snow-leopard-rails/176663/5 "2009-10-05T14:00:05Z")
On 4 Ott, 22:05, tspore [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > leopard, I didn’t upgrade correctly or something. Teaches me to do a > > > you can always try in command line ‘mysql -u root -p’ press enter and type > > in the password. > > If it works, it is correct. > > > Trausti Is the port correct?