rails3: unable to logon to database

Question

Hi there,

in my account i have created a mysql database, and a rails 3 application.

I edited the database.yml as specified in this article, and i got the following error:

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

I then replaced the localhost in my database.yml to web164 (because i saw in my webfaction dashboard that that was the name of the db-machine). But then i get the following error:

Mysql::Error: Access denied for user 'root'@'web164.webfaction.com' (using password: YES)

I am able to get into my database using phpmysql, so my password should be correct. Anybody has a clue as to what could be wrong?

For completeness, here is my database.yml:

production: &db
  adapter: mysql
  database: nathanvda_voc
  user: nathanvda_voc
  password: *******
  host: web164

development:
  <<: *db

(i have obscured my password of course)

Answer 1

0

Ha! I found it! I was able to connect to the database from the rails console using ActiveRecord::Base.establish_connection using an example from the documentation.

Sooooo, what was the difference? Apparently inside the database.yml you have to specify :username and not :user.

So i had to write it as follows to make it work:

production: &db
  adapter: mysql
  database: nathanvda_voc
  username: nathanvda_voc
  password: *******
  host: localhost

(and as you see: i could even use localhost then).

permanent link

answered 16 Jan '11, 13:21

nathanvda
7●5●10
accept rate: 0%

That explains it :)

Since you did not provide 'username' as a parameter, the DB server assumed you were connecting as root, hence the error message.

For what it's worth, our documentation does specify 'username'. :)

(16 Jan '11, 13:38) seanf

I noticed that too :) The error was completely on my part ;)

(16 Jan '11, 14:10) nathanvda

rails3: unable to logon to database

Follow this question

Related questions