blob: 49dbe0fe95f0e7f2ae649fb7b0b0ede1c7187aba (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
#! /bin/bash
# determine IP pattern associated with 'eth0' (assume net mask = 255.255.0.0)
ipPattern=$(ifconfig eth0|sed -n -e 's/^.*inet addr:\([^\.]*.[^\.]*\)\..*$/\1.%.%/p')
# start MySQL, and grant all privileges to the local network
# (it doesn't hurt to do the 'grant' multiple times)
service mysql start
mysql -uroot -psecret \
-e "grant all privileges on *.* to 'policy_user'@'${ipPattern}' identified by 'policy_user' with grant option;"
exec sleep 1000d
|