on-rails服务器无法连接到mysql

lsmd5eda  于 2021-06-20  发布在  Mysql
关注(0)|答案(2)|浏览(253)

所有人。我正在尝试在MacOSX上建立以mysql为数据库的Rails3项目。但是,我收到下一个错误:
/usr/local/bundle/gems/activerecord-3.2.22.5/lib/active\u record/connection\u adapters/abstract/connection\u specification.rb:68:in connection\u url\u to\u hash:未定义的方法'sub'fornil:nilclass (命名者)
配置/database.yml

default: &default
  adapter: mysql2
  pool: 5
  encoding: utf8
  min_messages: warning
  timeout: 5000
  username: root
  password:
  database: heart_development
  host: localhost

有人能建议如何解决这个问题吗?

qoefvg9y

qoefvg9y1#

从您共享的database.yml和发布的日志来看,似乎无法找到数据库所在的路径。
将database.yml更改为

default: &default
  adapter: mysql2
  pool: 5
  encoding: utf8
  min_messages: warning
  timeout: 5000
  username: root
  password:
  database: heart_development
  host: localhost

数据库必须连接到的指定主机。

qfe3c7zg

qfe3c7zg2#

我评论了环境变量 DATABASE_URL 在我的 .env 文件。我还配置了 database.yml 接下来:

development:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: heart_development
  pool: 5
  username: root
  password:
  host: localhost
  port: 3306

test:
  adapter: mysql2
  encoding: utf8
  reconnect: false
  database: heart_test
  pool: 5
  username: root
  password:
  host: localhost
  port: 3306

production:
  adapter: mysql2
  encoding: utf8cm
  reconnect: false
  database: heart_production
  pool: 5
  username: root
  password:
  host: localhost
  port: 3306

相关问题