3 ## admin.sql -- MySQL commands for creating the RADIUS user.
5 ## WARNING: You should change 'localhost' and 'radpass'
6 ## to something else. Also update raddb/sql.conf
7 ## with the new RADIUS password.
12 # Create default administrator for RADIUS
14 CREATE USER 'radius'@'localhost';
15 SET PASSWORD FOR 'radius'@'localhost' = PASSWORD('radpass');
17 # The server can read any table in SQL
18 GRANT SELECT ON radius.* TO 'radius'@'localhost';
20 # The server can write to the accounting and post-auth logging table.
23 GRANT ALL on radius.radacct TO 'radius'@'localhost';
24 GRANT ALL on radius.radpostauth TO 'radius'@'localhost';