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?
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 R.
<[email protected]
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 R. [email protected]
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.
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 