yliu-xjtu
7/9/2017 - 2:04 PM

Windows Batch Scripts for Mysql (English and Chinese Version)

Windows Batch Scripts for Mysql (English and Chinese Version)

register_zh.bat
content_copyfile_download
@echo off
:: BatchGotAdmin
:-------------------------------------
REM --> Check for permissions
>nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"

REM --> If error flag set, we do not have admin.
if '%errorlevel%' NEQ '0' (
echo Requesting administrative privileges...
goto UACPrompt
) else ( goto gotAdmin )

:UACPrompt
echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs"
echo UAC.ShellExecute "%~s0", "", "", "runas", 1 >> "%temp%\getadmin.vbs"

"%temp%\getadmin.vbs"
exit /B

:gotAdmin
if exist "%temp%\getadmin.vbs" ( del "%temp%\getadmin.vbs" )
pushd "%CD%"
CD /D "%~dp0"
:--------------------------------------
cd bin

:dosmenu
REM 选择菜单
echo #**********************************************************************#
echo       Mysql 服务注册脚本 
echo #**********************************************************************#
echo       命令相关参数说明如下 快速切换
echo #**********************************************************************#
echo.
echo [1]注册mysql服务   [2]卸载mysql服务 
echo 其它键退出本程序 
echo.
echo #**********************************************************************#
set /P CHS= 请选择: [1],[2] 后回车?

if /I "%CHS%"=="1" (
goto 1111
)
if /I "%CHS%"=="2" (
goto 2222
)
goto eeee
:1111
REM 注册mysql服务 
mysqld install mysql
pause
cls
goto dosmenu
:2222
REM 卸载mysql服务
sc delete mysql
pause
cls
goto dosmenu
:eeee
REM 退出
exit
register_en.bat
content_copyfile_download
@echo off
:: BatchGotAdmin
:-------------------------------------
REM --> Check for permissions
>nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"

REM --> If error flag set, we do not have admin.
if '%errorlevel%' NEQ '0' (
echo Requesting administrative privileges...
goto UACPrompt
) else ( goto gotAdmin )

:UACPrompt
echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs"
echo UAC.ShellExecute "%~s0", "", "", "runas", 1 >> "%temp%\getadmin.vbs"

"%temp%\getadmin.vbs"
exit /B

:gotAdmin
if exist "%temp%\getadmin.vbs" ( del "%temp%\getadmin.vbs" )
pushd "%CD%"
CD /D "%~dp0"
:--------------------------------------
cd bin

:dosmenu
REM Menu
echo #**********************************************************************#
echo       Mysql Service (U)install Script 
echo #**********************************************************************#
echo       Command Parameters are as follows (quick switch)
echo #**********************************************************************#
echo.
echo [1]Install mysql service   [2]Uinstall mysql service 
echo Any other keys to exit!
echo.
echo #**********************************************************************#
set /P CHS= Please Select: [1],[2] and then press enter?

if /I "%CHS%"=="1" (
goto 1111
)
if /I "%CHS%"=="2" (
goto 2222
)
goto eeee
:1111
REM install mysql service 
mysqld install mysql
pause
cls
goto dosmenu
:2222
REM uinstall mysql service
sc delete mysql
pause
cls
goto dosmenu
:eeee
REM quit
exit
mysql_zh.bat
content_copyfile_download
@echo off
:: BatchGotAdmin
:-------------------------------------
REM --> Check for permissions
>nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"

REM --> If error flag set, we do not have admin.
if '%errorlevel%' NEQ '0' (
echo Requesting administrative privileges...
goto UACPrompt
) else ( goto gotAdmin )

:UACPrompt
echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs"
echo UAC.ShellExecute "%~s0", "", "", "runas", 1 >> "%temp%\getadmin.vbs"

"%temp%\getadmin.vbs"
exit /B

:gotAdmin
if exist "%temp%\getadmin.vbs" ( del "%temp%\getadmin.vbs" )
pushd "%CD%"
CD /D "%~dp0"
:--------------------------------------


:dosmenu
REM 选择菜单
echo #**********************************************************************#
echo       Mysql 服务启动脚本 
echo #**********************************************************************#
echo       命令相关参数说明如下 快速切换
echo #**********************************************************************#
echo.
echo [1]启动mysql   [2]关闭mysql 
echo 其它键退出本程序 
echo.
echo #**********************************************************************#
set /P CHS= 请选择: [1],[2] 后回车?

if /I "%CHS%"=="1" (
goto 1111
)
if /I "%CHS%"=="2" (
goto 2222
)
goto eeee
:1111
REM 启动mysql 
net start MySQL
pause
cls
goto dosmenu
:2222
REM 关闭mysql
net stop MySQL
pause
cls
goto dosmenu
:eeee
REM 退出
exit
mysql_en.bat
content_copyfile_download
@echo off
:: BatchGotAdmin
:-------------------------------------
REM --> Check for permissions
>nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"

REM --> If error flag set, we do not have admin.
if '%errorlevel%' NEQ '0' (
echo Requesting administrative privileges...
goto UACPrompt
) else ( goto gotAdmin )

:UACPrompt
echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs"
echo UAC.ShellExecute "%~s0", "", "", "runas", 1 >> "%temp%\getadmin.vbs"

"%temp%\getadmin.vbs"
exit /B

:gotAdmin
if exist "%temp%\getadmin.vbs" ( del "%temp%\getadmin.vbs" )
pushd "%CD%"
CD /D "%~dp0"
:--------------------------------------


:dosmenu
REM Menu
echo #**********************************************************************#
echo       Mysql Service Startup Script 
echo #**********************************************************************#
echo       Command Parameters are as follows (quick switch)
echo #**********************************************************************#
echo.
echo [1]start mysql   [2]stop mysql 
echo Any other keys to exit! 
echo.
echo #**********************************************************************#
set /P CHS= Please Select: [1],[2] and then press enter?

if /I "%CHS%"=="1" (
goto 1111
)
if /I "%CHS%"=="2" (
goto 2222
)
goto eeee
:1111
REM start mysql 
net start MySQL
pause
cls
goto dosmenu
:2222
REM stop mysql
net stop MySQL
pause
cls
goto dosmenu
:eeee
REM quit
exit
README.md
content_copyfile_download
  • Rendered
  • Source

Windows Batch Scripts for MySQL (English and Chinese Version)

These are Windows batch files for quickly managing MySQL, especially useful for the Zipped version.

  • mysql_en.bat English version for starting and stopping mysql service
  • mysql_zh.bat Chinese version for starting and stopping mysql service
  • register_en.bat English version for installing and uinstalling mysql service
  • register_zh.bat Chinese version for installing and uinstalling mysql service