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?
on 2009-03-10 13:44
on 2009-03-10 14:01
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 <email@example.com
on 2009-03-10 15:16
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>
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.
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 :)