"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
