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

Reply via email to