Forum: Ruby on Rails RoR on Bluehost

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
E7f72bb97b38ad473b23645dffb9e442?d=identicon&s=25 Paul Reitz (paulreitz)
on 2009-03-10 13:44
Hi all. I'm having problems getting a RoR app to run on bluehost. Here's
the rundown. First I'm frustrated because I have two accounts, I've
gotten an app to run on one account, and I can't get one running on the
other. And I'm pretty sure I did everything the same.

On the one that isn't working, I keep getting the error page. When I
launch the console and try something like;
user = User.new
I get this error:
Mysql::Error: Access denied for user 'root'@'localhost' (using password:
YES)

Here's what I have in database.yml
production:
  adapter: mysql
  database: *******
  user: ******
  password: ******
  host: localhost
  socket: /var/lib/mysql/mysql.sock
  timeout: 5000

I copied and pasted the database name, user name and password (database
name and user name are prepended with my account name)

I've checked the permissions on the public folder and on dispatch.*
I need to get this site running asap, anyone have any ideas?
536253930b065b5a5e8ff9b204c85001?d=identicon&s=25 Sean McGilvray (Guest)
on 2009-03-10 14:01
(Received via mailing list)
Wouldn't you database name and user name be different for the
different account?  If you just copied them then your trying to access
the database name under the other account. If I am not mistaken you
can not do this with shared hosting on bluehost.

Sean McGilvray

Sent from my iPhone

On Mar 10, 2009, at 5:44 AM, Paul Reitz
<rails-mailing-list@andreas-s.net
668b05a67be34fca9b9fdad67351ef11?d=identicon&s=25 Geekyra (Guest)
on 2009-03-10 15:16
(Received via mailing list)
at least create ur own MySQL account from ur cpanel....
U can't access the database as root.

On Mar 10, 7:44 pm, Paul Reitz <rails-mailing-l...@andreas-s.net>
E7f72bb97b38ad473b23645dffb9e442?d=identicon&s=25 Paul Reitz (paulreitz)
on 2009-03-10 15:23
Uhm yeah. To specify, when I said I copied and pasted the user name and
password and stuff, I meant that I copied it from cpanel on the second
account, to make sure that the user name, password, and database name
were correct. Also, I'm not trying to access mysql as root, that's the
point. That's why the error makes no sense. I don't know why it's trying
to access the database as root, it shouldn't be.
E7f72bb97b38ad473b23645dffb9e442?d=identicon&s=25 Paul Reitz (paulreitz)
on 2009-03-11 05:59
After a very long and stressful day, I finally found my problem
(actually someone on the bluehost forum had the same problem:) )
in my database.yml file I had 'user' instead of 'username'. A complete
n00b mistake on my part, but there it is in case some one gets the same
error :)
This topic is locked and can not be replied to.