I"m getting this error Access denied for user: ''root@localhost'' (Using password: NO) I''ve googled around and realize it can be any number of things. The yml file is set up correct and I can login into database through shell. Any ideas what to try next ? TIA Stuart -- http://en.wikipedia.org/wiki/Dark_ambient --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
> I"m getting this error > Access denied for user: ''root@localhost'' (Using password: NO) > > I''ve googled around and realize it can be any number of things. The yml > file is set up correct and I can login into database through shell. > Any ideas what to try next ?yml file has several setting for different environments. Are you sure you have set them all of them correctly? Maybe you have correct settings for, say, development evnvironment, but try to run rails in production mode? Regards, Rimantas -- http://rimantas.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 -~----------~----~----~----~------~----~------~--~---
On 11/10/06, Rimantas Liubertas <rimantas-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > > > I"m getting this error > > Access denied for user: ''root@localhost'' (Using password: NO) > > > > I''ve googled around and realize it can be any number of things. The yml > > file is set up correct and I can login into database through shell. > > Any ideas what to try next ? > > yml file has several setting for different environments. Are you sure > you have set > them all of them correctly? Maybe you have correct settings for, say, > development evnvironment, but try to run rails in production mode? > > Regards, > Rimantas > --Well they are all set for their environments. I wonder though if the SQL server needs to be rebooted. The other thing is that it seems to be version 3.23 of MySQL , pretty old and wonder if that would effect anything ? Stuart --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
On Fri, 2006-11-10 at 02:38 -0700, Dark Ambient wrote:> On 11/10/06, Rimantas Liubertas <rimantas-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > I"m getting this error > > Access denied for user: ''root@localhost'' (Using password: > NO) > > > > I''ve googled around and realize it can be any number of > things. The yml > > file is set up correct and I can login into database through > shell. > > Any ideas what to try next ? > > yml file has several setting for different environments. Are > you sure > you have set > them all of them correctly? Maybe you have correct settings > for, say, > development evnvironment, but try to run rails in production > mode? > > Regards, > Rimantas > -- > > Well they are all set for their environments. I wonder though if the > SQL server needs to be rebooted. > > > The other thing is that it seems to be version 3.23 of MySQL , pretty > old and wonder if that would effect anything ?---- I couldn''t connect to 3.23 when I first started with Rails and gave up and updated to MySQL 4.1.x which was easy enough. Then I had to flip the switch to old_passwords=1 to 0 in my.cnf to make Rails work. This was an Red Hat based system. Craig --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
On Fri, 2006-11-10 at 02:23 -0700, Dark Ambient wrote:> I"m getting this error > Access denied for user: ''root@localhost'' (Using password: NO) > > I''ve googled around and realize it can be any number of things. The > yml file is set up correct and I can login into database through > shell. > Any ideas what to try next ?---- and by the way, once you get connected, learn to set up users/grants and don''t allow root to connect without a password Craig --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
On 11/10/06, Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote:> > > On Fri, 2006-11-10 at 02:23 -0700, Dark Ambient wrote: > > I"m getting this error > > Access denied for user: ''root@localhost'' (Using password: NO) > > > > I''ve googled around and realize it can be any number of things. The > > yml file is set up correct and I can login into database through > > shell. > > Any ideas what to try next ? > ---- > and by the way, once you get connected, learn to set up users/grants and > don''t allow root to connect without a password > > CraigYep, this server I''m on is Redhat as well. Well I don''t have root connecting to anything. I have a unique username and password which was set to grant all . I think though at this point I''m down to either rebooting the sql server or upgrading (which will probably involve a reboot) Stuart> >-- http://en.wikipedia.org/wiki/Dark_ambient --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Hi Stuart, When, exactly, do you get this message? During your application''s execution? When you''re interacting with MySQL via the command line? What platform are you getting this on? Bill ----- Original Message ----- From: Dark Ambient To: rubyonrails-talk Sent: Friday, November 10, 2006 3:23 AM Subject: [Rails] Access denied for user:- I"m getting this error Access denied for user: ''root@localhost'' (Using password: NO) I''ve googled around and realize it can be any number of things. The yml file is set up correct and I can login into database through shell. Any ideas what to try next ? TIA Stuart -- http://en.wikipedia.org/wiki/Dark_ambient --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
On Fri, 2006-11-10 at 05:00 -0700, Dark Ambient wrote:> On 11/10/06, Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: > > On Fri, 2006-11-10 at 02:23 -0700, Dark Ambient wrote: > > I"m getting this error > > Access denied for user: ''root@localhost'' (Using password: > NO) > > > > I''ve googled around and realize it can be any number of > things. The > > yml file is set up correct and I can login into database > through > > shell. > > Any ideas what to try next ? > ---- > and by the way, once you get connected, learn to set up > users/grants and > don''t allow root to connect without a password > > Craig > > Yep, this server I''m on is Redhat as well. > Well I don''t have root connecting to anything. I have a unique > username and password which was set to grant all .---- above says ''Access denied for user: root@localhost (using password: NO) ----> I think though at this point I''m down to either rebooting the sql > server or upgrading (which will probably involve a reboot)---- Redhat does have mysql server/client 4.1.12 for RHEL 3 - I think it''s in ''unsupported'' Craig --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
On 11/10/06, Bill Walton <bill.walton-xwVYE8SWAR3R7s880joybQ@public.gmane.org> wrote:> > Hi Stuart, > > When, exactly, do you get this message? During your application''s > execution? When you''re interacting with MySQL via the command line? > What platform are you getting this on? > > Bill >Hi Bill!, I get the message when I''m attempting to load a page that loads a table. I can get in command line with no problem, selects, etc. Red Hat Linux. Stuart ----- Original Message -----> *From:* Dark Ambient <sambient-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > *To:* rubyonrails-talk <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > *Sent:* Friday, November 10, 2006 3:23 AM > *Subject:* [Rails] Access denied for user:- > > I"m getting this error > Access denied for user: ''root@localhost'' <%27root@localhost%27> (Using > password: NO) > > I''ve googled around and realize it can be any number of things. The yml > file is set up correct and I can login into database through shell. > Any ideas what to try next ? > > TIA > Stuart > > -- > http://en.wikipedia.org/wiki/Dark_ambient > > > >-- http://en.wikipedia.org/wiki/Dark_ambient --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Hi Stuart,
If you can login from the shell as root without a password, then my first guess
would be that you must not appear to MySQL as coming in on the localhost domain
when you do that. This sounds like something you should continue to investigate
and get straightened out.
Having said that...
For a quick ''fix'', have you tried just doing a grant to that
user?
grant all on database_name.* to
''root''@''localhost''
hth,
Bill
----- Original Message -----
From: Dark Ambient
To: rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
Sent: Friday, November 10, 2006 10:52 AM
Subject: [Rails] Re: Access denied for user:-
On 11/10/06, Bill Walton
<bill.walton-xwVYE8SWAR3R7s880joybQ@public.gmane.org> wrote:
Hi Stuart,
When, exactly, do you get this message? During your application''s
execution? When you''re interacting with MySQL via the command line?
What platform are you getting this on?
Bill
Hi Bill!, I get the message when I''m attempting to load a page that
loads a table. I can get in command line with no problem, selects, etc.
Red Hat Linux.
Stuart
----- Original Message -----
From: Dark Ambient
To: rubyonrails-talk
Sent: Friday, November 10, 2006 3:23 AM
Subject: [Rails] Access denied for user:-
I"m getting this error
Access denied for user: ''root@localhost'' (Using
password: NO)
I''ve googled around and realize it can be any number of things.
The yml file is set up correct and I can login into database through shell.
Any ideas what to try next ?
TIA
Stuart
--
http://en.wikipedia.org/wiki/Dark_ambient
--
http://en.wikipedia.org/wiki/Dark_ambient
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
On 11/10/06, Bill Walton <bill.walton-xwVYE8SWAR3R7s880joybQ@public.gmane.org> wrote:> > Hi Stuart, > > If you can login from the shell as root without a password, then my first > guess would be that you must not appear to MySQL as coming in on the > localhost domain when you do that. This sounds like something you should > continue to investigate and get straightened out. >Only if I want my application to work :) Having said that...> > For a quick ''fix'', have you tried just doing a grant to that user? > > grant all on database_name.* to ''root''@''localhost''<%27root%27@%27localhost%27> >Just tried it and same response. access denied ...root@localhost.....using password ''no'' I rebooted mysql so I can confidently rule that out. Next step is to upgrade to 4.x, since Rails recommends at least 4. Stuart hth,> Bill > > ----- Original Message ----- > *From:* Dark Ambient <sambient-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > *To:* rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org > *Sent:* Friday, November 10, 2006 10:52 AM > *Subject:* [Rails] Re: Access denied for user:- > > On 11/10/06, Bill Walton <bill.walton-xwVYE8SWAR3R7s880joybQ@public.gmane.org> wrote: > > > > Hi Stuart, > > > > When, exactly, do you get this message? During your application''s > > execution? When you''re interacting with MySQL via the command line? > > What platform are you getting this on? > > > > Bill > > > > > Hi Bill!, I get the message when I''m attempting to load a page that loads > a table. I can get in command line with no problem, selects, etc. > Red Hat Linux. > > Stuart > > ----- Original Message ----- > > *From:* Dark Ambient <sambient-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > > *To:* rubyonrails-talk <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > > *Sent:* Friday, November 10, 2006 3:23 AM > > *Subject:* [Rails] Access denied for user:- > > > > I"m getting this error > > Access denied for user: ''root@localhost'' <%27root@localhost%27> (Using > > password: NO) > > > > I''ve googled around and realize it can be any number of things. The yml > > file is set up correct and I can login into database through shell. > > Any ideas what to try next ? > > > > TIA > > Stuart > > > > -- > > http://en.wikipedia.org/wiki/Dark_ambient > > > > > > > > > -- > http://en.wikipedia.org/wiki/Dark_ambient > > > >-- http://en.wikipedia.org/wiki/Dark_ambient --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Dark Ambient wrote:> Next step is to upgrade to 4.x, since > Rails recommends at least 4.Sounds like the right next step. Let us know how it goes. Best regards, Bill --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Will do Stuart On 11/10/06, Bill Walton <bill.walton-xwVYE8SWAR3R7s880joybQ@public.gmane.org> wrote:> > > Dark Ambient wrote: > > Next step is to upgrade to 4.x, since > > Rails recommends at least 4. > > Sounds like the right next step. Let us know how it goes. > > Best regards, > Bill > > > >-- http://en.wikipedia.org/wiki/Dark_ambient --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---