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: mysql@lists.mysql.com 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: mysql@lists.mysql.com > 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 >
