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? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org > wrote:> > 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? > -- > Posted via http://www.ruby-forum.com/. > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> 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? > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 :) -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---