Sorry to keep cluttering up the list like this, but I was having
permissions errors with the user setup script I sent. Here is a fixed
version (only can connect from localhost, for some reason the % host
substitutions did not work properly):
INSERT INTO user (Host, User, Password, Select_priv, Insert_priv,
Update_priv, Delete_priv) VALUES ('localhost', 'radius',
password('radius'), 'N', 'N', 'N', 'N');
INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv,
Delete_priv, Create_priv, Drop_priv, Grant_priv, References_priv,
Index_priv, Alter_priv) values ('localhost', 'FREERADIUS', 'radius',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
CREATE DATABASE FREERADIUS;
GRANT ALL on FREERADIUS.* TO "radius" IDENTIFIED BY "radius";
exit
On Tuesday, September 11, 2001, at 01:49 PM, Scott Wood wrote:
> Update on my last post, GRANT ALL... should come after the database is
> created.
> --Scott
>
> CREATE DATABASE FREERADIUS;
> GRANT ALL on FREERADIUS.* TO "radius@%" IDENTIFIED BY "radius";
>
> - List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html