Access denied for user:-

Rails
1

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

–

2

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/

3

On 11/10/06, Rimantas L. [email protected] wrote:

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

4

On Fri, 2006-11-10 at 02:38 -0700, Dark A. wrote:

    > Any ideas what to try next ?
    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

5

On Fri, 2006-11-10 at 02:23 -0700, Dark A. 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

6

On 11/10/06, Craig W. [email protected] wrote:

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 .
I think though at this point I’m down to either rebooting the sql server
or
upgrading (which will probably involve a reboot)

Stuart

–

7

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 A.
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

–
Dark ambient - Wikipedia

8

On Fri, 2006-11-10 at 05:00 -0700, Dark A. wrote:

    through

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

9

On 11/10/06, Bill W. [email protected] 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 -----

file is set up correct and I can login into database through shell.
Any ideas what to try next ?

TIA
Stuart

–
Dark ambient - Wikipedia

–

10

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 A.
To: [email protected]
Sent: Friday, November 10, 2006 10:52 AM
Subject: [Rails] Re: Access denied for user:-

On 11/10/06, Bill W. [email protected] 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 A.
  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

–
Dark ambient - Wikipedia

11

Dark A. 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

12

On 11/10/06, Bill W. [email protected] 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 :slight_smile:

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
[email protected]
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,

Hi Stuart,
a table. I can get in command line with no problem, selects, etc.
I"m getting this error

–

13

Will do
Stuart

On 11/10/06, Bill W. [email protected] wrote:

–