| Chetan Gaonker | 7f4bf74 | 2016-05-04 15:56:08 -0700 | [diff] [blame] | 1 | # -*- text -*- |
| 2 | ## |
| 3 | ## admin.sql -- MySQL commands for creating the RADIUS user. |
| 4 | ## |
| 5 | ## WARNING: You should change 'localhost' and 'radpass' |
| 6 | ## to something else. Also update raddb/sql.conf |
| 7 | ## with the new RADIUS password. |
| 8 | ## |
| 9 | ## $Id: 5c91384c0991ea9614b7c798a1ab4c89ca227115 $ |
| 10 | |
| 11 | # |
| 12 | # Create default administrator for RADIUS |
| 13 | # |
| 14 | CREATE USER 'radius'@'localhost'; |
| 15 | SET PASSWORD FOR 'radius'@'localhost' = PASSWORD('radpass'); |
| 16 | |
| 17 | # The server can read any table in SQL |
| 18 | GRANT ALL ON radius.* TO 'radius'@'localhost' identified by 'radpass'; |
| 19 | GRANT ALL ON radius.* TO 'radius'@'radsrvr' identified by 'radpass'; |
| 20 | |
| 21 | # The server can write to the accounting and post-auth logging table. |
| 22 | # |
| 23 | # i.e. |
| 24 | #GRANT ALL on radius.radacct TO 'radius'@'localhost' identified by 'radpass'; |
| 25 | #GRANT ALL on radius.radacct TO 'radius'@'radsrvr' identified by 'radpass'; |