#!/bin/sh
echo
echo ---------------------
echo Make MySQL deluser
echo ---------------------
NEED_ARGS=1

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

echo "use mysql" > $1.sql
echo "drop database $1;" >> $1.sql
echo "delete from user where user = '$1';" >> $1.sql
echo "delete from db where user = '$1';" >> $1.sql
echo "flush privileges;" >> $1.sql
echo Press MySQL Password for ROOT
mysql -u root -p mysql < $1.sql
echo Done.