OK, make sure you are using the correct password, too. Did you remember
to encrypt the password with PASSWORD() or OLD_PASSWORD() when you create
the account?
SELECT user, host, password
FROM mysql.user
WHERE user='radius';
make sure your password is hashed, if not we can help you fix that pretty
easily
UPDATE mysql.user
SET `password`=PASSWORD('plain-text-of-password')
WHERE user='radius';
FLUSH PRIVILEGES;
Then try again.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Atkins, Dwane P" <[EMAIL PROTECTED]> wrote on 03/23/2006 11:30:41 AM:
> I did do a FLUSH PRIVILEGES and this still resulted in the same error.
>
>
>
> ________________________________
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 23, 2006 10:31 AM
> To: Atkins, Dwane P
> Cc: [email protected]
> Subject: RE: Freeradius and MySql
>
>
>
>
> You could try suggestion B) ;-)
>
> Shawn
>
> "Atkins, Dwane P" <[EMAIL PROTECTED]> wrote on 03/23/2006 11:25:24 AM:
>
> > * a) Verify that you have actually GRANTED permission for the
> > account you are trying to authenticate with
> >
> > SELECT user, host from mysql.user where user ='radius';
> >
> >
> >
> > mysql> SELECT user, host from mysql.user where user ='radius';
> >
> > +--------+-----------+
> >
> > | user | host |
> >
> > +--------+-----------+
> >
> > | radius | % |
> >
> > | radius | localhost |
> >
> > +--------+-----------+
> >
> > 2 rows in set (0.00 sec)
> >
> >
> >
> > SHOW GRANTS FOR 'user'@'host';
> >
> >
> >
> > mysql> SHOW GRANTS FOR 'radius'@'localhost';
> >
> > +------------------------------------------------------------+
> >
> > | Grants for [EMAIL PROTECTED] |
> >
> > +------------------------------------------------------------+
> >
> > | GRANT USAGE ON *.* TO 'radius'@'localhost' |
> >
> > | GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' |
> >
> > +------------------------------------------------------------+
> >
> > 2 rows in set (0.00 sec)
> >
> >
> >
> >
> >
> > As you can see, it looks like I have granted permissions to the user,
> > [EMAIL PROTECTED] for db radius. I am not sure what to do next.
> >
> >
> >
> > Thanks
> >
> >
> >
> > Dwane
> >
> >
> >
> >
> >
> > ________________________________
> >
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, March 23, 2006 9:51 AM
> > To: Atkins, Dwane P
> > Cc: [email protected]
> > Subject: Re: Freeradius and MySql
> >
> >
> >
> >
> >
> > "Atkins, Dwane P" <[EMAIL PROTECTED]> wrote on 03/23/2006 10:38:57
> AM:
> >
> > > Good morning. I am trying to install Free Radius with MySql, but I
> > > either have a login issue or a permissions issue.
> > >
> > >
> > >
> > > I have added Radius and [EMAIL PROTECTED] to database, Fedora local
> > users
> > > and just about everywhere I can think possible. I have added
> > > permissions for radius & radius local to databases mysql and
> database
> > > radius. However, when I try to log in to mysql using the command
> > mysql
> > > -u radius -p radius, I get and error stating, "Error 1045 (28000):
> > > Access Denied for user 'radius'@'localhost' (using:Password: YES).
> I
> > am
> > > really frustrated since I have been working on this login and
> > permission
> > > issue for some time.
> > >
> > >
> > > Thanks
> > >
> > > <mailto:[EMAIL PROTECTED]>
> > >
> > >
> > >
> >
> > Try this:
> > a) Verify that you have actually GRANTED permission for the account
> you
> > are trying to authenticate with
> >
> > SELECT user, host from mysql.user where user ='radius';
> > Then for each user-host combination listed above do one of these and
> > compare the privileges listed to those you expected the accounts to
> > have.
> >
> > SHOW GRANTS FOR 'user'@'host';
> >
> > b) if the records exist but aren't being respected, issue a FLUSH
> > PRIVILEGES command. I have noticed that (in contradiction to the
> > documentation) that you sometimes need to manually refresh the
> privilege
> > cache even after using a GRANT or REVOKE command.
> >
> >
> > If those don't get you started, come back with whatever new
> information
> > you learn and we can try something else.
> >
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> >
>
