MYSQL 启动管理脚本工具
mysqlm.bat
---------------------------
@echo offsetlocalREM 首次使用需要配置settings下对应属性.:settingsset mysql_bin_dir=E:\bisoft\mysql5.1\binset user=rootset password=rootset host=localhostset port=3306set server=mysqld.exeset shutdown=mysqladmin.exe shutdownset client=mysql.exe:usageecho.echo ==========================================================================echo MySQL 数据库服务器管理工具 by amos_tl [11/05/01] echo.echo 启动服务器(s) echo 关闭服务器(e) echo 启动客户端(c)echo 帮助(h)echo 退出(q)echo.echo ==========================================================================echo.:mainset /p command=(%0):if "%command%"=="s" echo 启动MySQL服务器... & goto startServerif "%command%"=="e" echo 关闭MySQL服务器... & goto stopServerif "%command%"=="c" echo 启动MySQL客户端... & goto startClientif "%command%"=="h" goto usageif "%command%"=="q" goto endgoto main:startServerstart /MIN /B %mysql_bin_dir%\%server%if %errorlevel% == 0 echo MySQL服务器已启动if %errorlevel% == 1 echo MySQL服务器启动失败!goto main:startClientstart /MIN %mysql_bin_dir%\%client% -h %host% -P %port% -u %user% -p%password%goto main:stopServercall %mysql_bin_dir%\%shutdown% -h %host% -P %port% -u %user% -p%password%if %errorlevel% == 0 echo MySQL服务器已停止if %errorlevel% == 1 echo MySQL服务器停止失败!goto main:endendlocalexit
mysql -u root -puse mysqlupdate user set password=PASSWORD('123456') where host = 'localhost' and user = 'root';flush privileges;