summaryrefslogtreecommitdiffstats
path: root/raddb/mods-config/sql/dhcp/mysql/setup.sql
blob: d20a82c9ccb94cc1ec609a761b6a8f44d30e48c3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
/*
 * setup.sql -- MySQL commands for creating the RADIUS user.
 *
 *	WARNING: You should change 'localhost' and 'radpass'
 *		 to something else.  Also update raddb/mods-available/sql
 *		 with the new RADIUS password.
 *
 *	WARNING: This example file is untested.  Use at your own risk.
 *		 Please send any bug fixes to the mailing list.
 *
 *	$Id$
 */

/*
 *  Create default administrator for RADIUS
 */
CREATE USER 'radius'@'localhost' IDENTIFIED BY 'radpass';

GRANT SELECT ON radius.dhcpreply TO 'radius'@'localhost';
GRANT SELECT ON radius.dhcpgroupreply TO 'radius'@'localhost';
GRANT SELECT ON radius.dhcpgroup TO 'radius'@'localhost';