* 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
