重置mysql数据库shell脚本

#!/bin/bash
user=
pwd=

function help_info(){
    echo "Tool to reset mysql server"
    echo "Usage:"
    echo "$0 <user> <pwd>"
}


if [ $# -eq 2 ];then
    user=$1
    pwd=$2
elif [ $# -ne 2 ];then
    help_info
    exit 1
fi

src=/usr/local/mysql/data
cd $src
mv mysql mysql_bak && mv performance_schema performance_schema_bak &&  mv test test_bak >/dev/null 2>&1
rm -rf `ls | grep [^_bak]$`
mv mysql_bak mysql;mv performance_schema_bak performance_schema; mv test_bak test

service mysql restart
mysql_status=`service mysql status | grep  "MySQL running" | awk -F " " '{print $1 $2}'`
#echo $mysql_status
if [ "$mysql_status" == "MySQLrunning" ];then
	echo "MYSQL server is running"
else
   	echo "Begin to start mysql server..."
	kill -9 `ps -ef | grep "/usr/local/mysql/bin" | grep -v grep | awk -F " " '{print  $2}'`&& service mysql  start
fi


function clearData()
{
echo "Begin to reset  mysql server" 
mysql -h 127.0.0.1 -u$user -p$pwd << EOF
use mysql;delete from user where user not in('root','mysql');
delete from user where user='mysql' and host not in ('localhost','linux','127.0.0.1','::1','%');
stop slave ;reset master;
EOF
if [ $? -eq 0 ];then
echo "Reset mysql server sucessfully..." 
else
 echo "Reset mysql fail..."
fi

}
clearData