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