mysql - Rails 项目与 MySQL DB 的连接错误 - root 用户访问被拒绝

Question

使用 mysql db 运行 Rails 时出现此错误。基本上它不会授予 root 用户访问权限。我不知道为什么会这样，并且已经被这个问题困扰了一段时间了。

Mysql2::Error (Access denied for user 'root'@'localhost' (using password: YES)):
Rendered /Users/USER/.rvm/gems/ruby-1.9.2-p290/gems/actionpack- 3.1.0/lib/action_dispatch/middleware/templates/rescues/_trace.erb (1.3ms)
Rendered /Users/USER/.rvm/gems/ruby-1.9.2-p290/gems/actionpack-3.1.0/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (5.7ms)
Rendered /Users/USER/.rvm/gems/ruby-1.9.2-p290/gems/actionpack-3.1.0/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (17.7ms)

下面发布了我的Database.yml文件供您引用。我不确定如何检查 MYSQL 自动分配的密码？这是我电脑的登录密码吗？无论如何我该如何检查它。另外，我不能简单地在命令行上输入 mysql，我必须输入完整路径才能访问它。我该如何改变它。最重要的是我想知道如何解决这个访问被拒绝的问题。谢谢。在 Mac 上使用 mysql 5.5。 x86_64 构建。

# And be sure to use new-style password hashing:
# http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: project1_db
  pool: 5
  user : root
  username: root
  password: password
  host: localhost

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: project1_db
  pool: 5
  user : root
  username: root
  password: password
  host: localhost

production:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: project1_db
  pool: 5
  user : root
  username: root
  password: password
  host: localhost

Answer 1

Mysql 使用您在安装时设置的那个。有时它是空的。尝试 mysql -u root。如果有效 - 从数据库 yaml 中删除传递字符串。如果不为空 - https://stackoverflow.com/search?q=mysql+reset+password