GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,CREATE,DROP ON database.* 
TO user@'10.1.1.%' IDENTIFIED by 'password';

echo "Starting MySQL"
cd /usr/local/mysql; ./bin/safe_mysqld --user=mysql &

echo "Starting MySQL 4"
cd /usr/local/mysql-4; ./bin/mysqld_safe --user=mysql -L ./share/mysql/english &

(/etc/my.cnf)
[mysqld]
set-variable = max_connections=400
set-variable = wait_timeout=60



Upgrade MySQL script

Last modified: Wednesday, December 31 1969 @ 19:00 EST

WWW braindump.MrZesty.net

© Ian Samuel, 2012
http://braindump.MrZesty.net