重置mysql数据库shell脚本
#!/bin/bashuser=pwd=function help_info(){ echo "Tool to reset mysql server" echo "Usage:" echo "$0 <user> <pwd>"}if [ $# -eq 2 ];then user=$1 pwd=$2elif [ $# -ne 2 ];then help_info exit 1fisrc=/usr/local/mysql/datacd $srcmv mysql mysql_bak && mv performance_schema performance_schema_bak &&mv test test_bak >/dev/null 2>&1rm -rf `ls | grep [^_bak]$`mv mysql_bak mysql;mv performance_schema_bak performance_schema; mv test_bak testservice mysql restartmysql_status=`service mysql status | grep"MySQL running" | awk -F " " '{print $1 $2}'`#echo $mysql_statusif [ "$mysql_status" == "MySQLrunning" ];thenecho "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 mysqlstartfifunction clearData(){echo "Begin to resetmysql server" mysql -h 127.0.0.1 -u$user -p$pwd << EOFuse 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;EOFif [ $? -eq 0 ];thenecho "Reset mysql server sucessfully..." else echo "Reset mysql fail..."fi}clearData
页:
[1]