mysql - 如何db :setup mysql2 database?

Question

我在 Rails 5 上使用 mysql2 gem。如果有帮助的话，我还使用 AWS Cloud9 EC2 实例进行开发。

这是我收到的错误:

$ RAILS_ENV=development bundle exec rake db:setup 

rake aborted! 
Mysql2::Error::ConnectionError: 
Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

这是我的database.yml 文件:

development:
  adapter: mysql2
  socket: /var/mysql/mysql.sock
  database: wagn_development
  username: user
  password: user
  host: localhost

test:
  adapter: mysql2
  socket: /var/mysql/mysql.sock
  database: wagn_test
  username: user
  password: user
  host: localhost

production:
  adapter: mysql2
  socket: /var/mysql/mysql.sock
  database: wagn_production
  username: user
  password: user
  host: localhost

如何解决这个错误？

Answer 1

我相信这与 Rails 无关。

您使用的是 RDS 还是数据库位于同一台机器上？

您读过本文或尝试过其中任何一个吗？我相信这是相关的

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)