I didn't encrypt and that was going to be my next questions. How do I do that?
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 10:45 AM To: Atkins, Dwane P Cc: mysql@lists.mysql.com Subject: RE: Freeradius and MySql 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: 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 > > >
