Search code examples
ruby-on-railsrubyrubygemsdata-objects

DataObjects::ConnectionError after ruby upgrade(to 2.1.3)

DataObjects::ConnectionError: Access denied for user 'user'@'password' (using password: YES)

from /Users/username/.rvm/gems/ruby-2.1.3@gemset/gems/data_objects-0.10.15/lib/data_objects/connection.rb:79:in `initialize'

Ruby Version - 2.1.3 OS - Mac - 10.10.1

Can some one please get me a solution as I have spent a lot of time on it.

Solution

  • It seems you have a problem with your database configuration. By the message I suspect you are using MySQL as database.

    So instead of using sockets, maybe you are using host instead of sockets. Try something like this in your database.yml

    development:
  adapter: mysql2
  host: localhost
  username: root
  password: xxxx
  database: xxxx
  socket: /tmp/mysql.sock

    Also make sure you can access your database:

    mysql -u USER -pPASSWORD -D DATABASE