重置mysql数据库shell脚本

dinggela

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