rails连接mysql,“拒绝访问”； Rails连接到Mysql时

I have did all the procedures as mentioned in several places and I also learned from lynda.com video tutorial. I used Mac 10.7 and I installed rubystack. I created the databases, add and checked the database.yml here is you can see it again.

development:

adapter: mysql2

encoding: utf8

reconnect: false

host: localhost

database: simplecmsdevelopment

pool: 5

username: simple_cms

password: maiwandj

socket: /tmp/mysql.sock

Therefore, when I run rake db:schema:dump it print the following errors

bash-3.2$ rake db:schema:dump

/Applications/rubystack-1.9.3-18/ruby/lib/ruby/gems/1.9.1/gems/bundler-1.5.2/lib/bundler/runtime.rb:220: warning: Insecure world writable dir /usr/local/bin in PATH, mode 040777

rake aborted!

Access denied for user 'simplecms'@'localhost' (using password: YES)

/Applications/rubystack-1.9.3-18/simplecms/config/environment.rb:5:in `' Tasks: TOP => db:schema:dump => environment (See full trace by running task with --trace)

解决方案

Have you granted permissions for that user on that database? i.e., GRANT ALL PRIVILEGES ON simplecmsdevelopment.* TO simple_cms@localhost;