修改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，如需轉載請自行聯系原作者