mysql启动停止使用命令

shutdown_mysql.bat如下：

@echo off
echo database server is stoping now...
set BASEDIR=%CD%
rem 把\改为/
set BASEDIR=%BASEDIR:\=/%
%BASEDIR%/bin/mysqladmin --user=root --password=root shutdown
rem %BASEDIR%/bin/mysql -u root --password=root stop
echo shutdown database server finished

 

 

startup_mysql.bat如下：

 

@echo off
set BASEDIR=%CD%
rem 把\改为/
set BASEDIR=%BASEDIR:\=/%
set DATADIR=%BASEDIR%/data
echo database server is strating now...  
start %BASEDIR%/bin/mysqld.exe --log-error=%BASEDIR%/data/windows.err
echo database server start finished