重置mysq root密码脚本

你是不是遇到过这样的问题？

1、一不小心，把刚安装的mysql root用户的密码忘记了。

2、根据网上很多教程修改后，还是提示ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES) 。

3、一不小心，用root登陆mysql的时候，出现Access denied for user ‘root’@'localhost’ (using password: YES) 这样的错误。

如果碰巧你真的遇到上述问题，又或者是类似的问题，那么下面的这个脚本对你很适用！

把下面的内容，保存成reset_mysql_root_password.sh，然后修改相应的MySQL管理脚本，在/etc/init.d/mysql。mysql安装在/usr/local/mysql/他们的相应位置，最后执行sh reset_mysql_root_password.sh

#!/bin/bash PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin export PATH # Check if user is root if [ $(id -u) != "0" ]; then printf "Error: You must be root to run this script!\n" exit 1 fi echo "=========================================================================\n" printf "Reset root Password! \n" printf "Request management script must be /etc/init.d/mysql \n" printf "And Mysql must be installed /usr/local/mysql/ \n" printf "If not, please revise the appropriate location. \n" printf "\n" printf "=========================================================================\n" printf "Usage: sh reset_mysql_root_password.sh\n" printf "=========================================================================\n" #Set mysql root password. mysql_root_password="" read -p "(Please input New MySQL root password):" mysql_root_password if [ "$mysql_root_password" = "" ]; then echo "Error: Password can't be NULL!!\n" exit 1 fi #Stoping MySQLd. printf "Stoping MySQL...\n" /etc/init.d/mysql stop #Starting Mysqld_safe printf "Starting MySQL with skip grant tables\n" /usr/local/mysql/bin/mysqld_safe --skip-grant-tables >/dev/null 2>&1 & printf "using mysql to flush privileges and reset password\n" sleep 10 #Set Mysql root password printf "update user set password = Password('$mysql_root_password') where User = 'root'\n" /usr/local/mysql/bin/mysql -u root mysql << EOF update user set password = Password('$mysql_root_password') where User = 'root'; EOF #Check Password successfully orfailed reset_status=`echo $?` if [ $reset_status = "0" ]; then printf "Password reset succesfully. Now killing mysqld softly\n" killall mysqld sleep 10 #Restarting mysqld printf "Restarting the actual mysql service\n" /etc/init.d/mysql start printf "Password successfully reset to '$mysql_root_password'\n" else printf "Reset MySQL root password failed!\n" fi