修改mysql密码批处理

@echo off

ECHO 正在更改MYSQL密码

echo use mysql >C:\mysqlpass.txt

echo update user set password=password("mima") where user="root";>>C:\mysqlpass.txt

echo flush privileges; >>C:\mysqlpass.txt

net stop mysql 2>nul

reg query "HKLM\SYSTEM\ControlSet001\Services\mysql" /t REG_EXPAND_SZ |find /i "image" >C:\mysql.txt

if %errorlevel% neq 0 goto exit

FOR /F "tokens=2,3* delims= " %%i in (C:\mysql.txt) do echo %%j %%k >C:\mysqltemp.txt

FOR /F "tokens=1 delims=-" %%i in (C:\mysqltemp.txt) do set mysqlpath=%%i

del C:\mysql.txt /f

del C:\mysqltemp.txt /f

set mysqlpath=%mysqlpath:/=\%

set mysqlpath=%mysqlpath:"=%

SET mysqlpath=%mysqlpath:~0,-6%

if %mysqlpath:~-1% neq \ set mysqlpath=%mysqlpath:~0,-1%

cd /d "%mysqlpath%"

start mysqld-nt.exe --skip-grant-tables

mysql <C:\mysqlpass.txt

if %errorlevel% neq 0 goto out

goto ok

:exit

echo 没有发现MYSQL

pause

del C:\mysqlpass.txt /f

exit

:out

echo 密码设置失败

:ok

taskkill /f /im mysqld-nt.exe >nul

echo 密码已成功设成mima，已复制到剪切板

echo mima|clip

net start mysql

本文转自 freeterman 51CTO博客，原文链接：http://blog.51cto.com/myunix/1095050，如需转载请自行联系原作者