#!/bin/sh
echo
echo ---------------------
echo Make MySQL adduser
echo ---------------------
NEED_ARGS=2

if [ $# -ne "$NEED_ARGS" ]
then
echo Usage: mysql_add.sh USERID PASSWORD
echo
exit $OPTERROR
fi

echo "use mysql" > $1.sql
echo "create database $1;" >> $1.sql
echo "insert into user (host,user,password) values ('localhost','$1',password('$2'));" >> $1.sql
echo "insert into db values('localhost','$1','$1','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y');" >> $1.sql
echo "flush privileges;" >> $1.sql
echo Press MySQL Password for ROOT
mysql -u root -p mysql < $1.sql
echo Done.