* 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 radius@localhost |
+------------------------------------------------------------+
| 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,
radius@localhost for db radius. I am not sure what to do next.
Thanks
Dwane
________________________________
From: SGreen@stripped [mailto:SGreen@stripped]
Sent: Thursday, March 23, 2006 9:51 AM
To: Atkins, Dwane P
Cc: mysql@stripped
Subject: Re: Freeradius and MySql
"Atkins, Dwane P" <ATKINSD@stripped> 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 radius@localhost 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:atkinsd@stripped>
>
>
>
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
