#! /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