Implementation script for resetting mysql's root password with one click

@echo off

title mysql

::Find it from the registryMysqlThe installation path is written to the file
reg query HKLM\SYSTEM\ControlSet001\Services\MySQL | find /I "ImagePath">C:\
if %errorlevel% neq 0 (
echo MySQL not found
pause
exit
)

::by”as a separator，Snap the second paragraph and save it to a variablemysqlPath
FOR /F tokens^=2^ delims^=^" %%i in (C:\) do set mysqlPath=%%i
del C:\ /f

::In the path/Replace with\
set mysqlPath=%mysqlPath:/=\%

::Delete the last character of the path（This character is not visible，Maybe it's carriage return or something like that）
set mysqlPath=%mysqlPath:~0,-1%

:BACKTOMAIN

::The last character of the path is not equal to\
set character=%mysqlPath:~-1,1%

::If the last character is not equal to\，Then jump toGETPATHdeletemysqlPathThe last character
if not %character% == \ goto GETPATH

::EntermysqlInstallation pathC:\Program Files\MySQL\MySQL Server 5.0\bin
cd /d "%mysqlPath%"

::echo %mysqlPath%

if %errorlevel% neq 0 (
echo MySQL not found
pause
exit
) 

::DisabledmysqlServe，Skip permission verification to modify password
taskkill /F /IM 
net stop mysql >nul
start /b mysqld-nt --skip-grant-tables
ping -n 2 127.0.0.1 >nul
echo use mysql >c:\
echo update user set password=password("") where user="root";>>C:\
echo flush privileges; >>C:\
echo exit >>C:\

::Because it's interactive，所by从文件读取内容
mysql <C:\
taskkill /F /IM 
net stop mysql >nul
net start mysql
del C:\ /F
pause
exit

::Delete the last character of the path，Jump back to the main program
:GETPATH
set mysqlPath=%mysqlPath:~0,-1%
goto BACKTOMAIN
If it is usedwampOne-click installation requires some scripts，Mainly, the registry search path changes，Change of return value，Serve名改变了，mysqlInstallation path变成D:\wamp\bin\mysql\mysql5.5.24\bin，Lessmysqld-ntThis thing，There is no in the process
@echo off

title mysql

reg query HKLM\SYSTEM\ControlSet001\Services\wampmysqld | find /I "ImagePath">C:\

if %errorlevel% neq 0 (
echo MySQL not found
pause
exit
)

FOR /F "tokens=3 delims= " %%i in (C:\) do set mysqlPath=%%i
del C:\ /f
set mysqlPath=%mysqlPath:/=\%
set mysqlPath=%mysqlPath:~0,-1%

:BACKTOMAIN
set character=%mysqlPath:~-1,1%
if not %character% == \ goto GETPATH
cd /d "%mysqlPath%"

::echo %mysqlPath%

if %errorlevel% neq 0 (
echo MySQL not found
pause
exit
)

taskkill /F /IM 
net stop wampmysqld >nul
start /b mysqld -nt --skip-grant-tables
ping -n 2 127.0.0.1 >nul
echo use mysql >c:\
echo update user set password=password("") where user="root";>>C:\
echo flush privileges; >>C:\
echo exit >>C:\

mysql <C:\

taskkill /F /IM 
net stop wampmysqld >nul
net start wampmysqld
del C:\ /F

pause
exit

:GETPATH
set mysqlPath=%mysqlPath:~0,-1%
goto BACKTOMAIN