批处理修改mysql密码_修改mysql密码批处理-阿里云开发者社区

@echo offECHO 正在更改MYSQL密码echo use mysql >C:\mysqlpass.txtecho update user set password=password("mima") where user="root";>>C:\mysqlpass.txtecho flush privileges; >>C:\mysqlpass.txtnet stop mysql 2>nulreg query "HKLM\SYSTEM\ControlSet001\Services\mysql" /t REG_EXPAND_SZ |find /i "image" >C:\mysql.txtif %errorlevel% neq 0 goto exitFOR /F "tokens=2,3* delims= " %%i in (C:\mysql.txt) do echo %%j %%k >C:\mysqltemp.txtFOR /F "tokens=1 delims=-" %%i in (C:\mysqltemp.txt) do set mysqlpath=%%idel C:\mysql.txt /fdel C:\mysqltemp.txt /fset 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-tablesmysql nulecho 密码已成功设成mima，已复制到剪切板echomima|clippause

net start mysql

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