| # -*- text -*- |
| ## |
| ## admin.sql -- MySQL commands for creating the RADIUS user. |
| ## |
| ## WARNING: You should change 'localhost' and 'radpass' |
| ## to something else. Also update raddb/sql.conf |
| ## with the new RADIUS password. |
| ## |
| ## $Id: aff0505a473c67b65cfc19fae079454a36d4e119 $ |
| |
| # |
| # Create default administrator for RADIUS |
| # |
| CREATE USER 'radius'@'localhost'; |
| SET PASSWORD FOR 'radius'@'localhost' = PASSWORD('radpass'); |
| |
| # The server can read any table in SQL |
| GRANT SELECT ON radius.* TO 'radius'@'localhost'; |
| |
| # The server can write to the accounting and post-auth logging table. |
| # |
| # i.e. |
| GRANT ALL on radius.radacct TO 'radius'@'localhost'; |
| GRANT ALL on radius.radpostauth TO 'radius'@'localhost'; |