nb-local/mysql/install.bat

@cd /d %~dp0
@%1 start "" mshta vbscript:createobject("shell.application").shellexecute("""%~0""","::",,"runas",1)(window.close)&exit
:以管理员身份运行cmd
@echo off 
setlocal enabledelayedexpansion 
:变量延迟的启动语句是“setlocal enabledelayedexpansion”，并且变量要用一对叹号“!!”括起来（注意要用英文的叹号）
echo 开始时间 %date%%time% >> ./install_log.txt 
echo ****************检测是否存在mysql服务*****************
echo.
SC QUERY mysql > NUL
if !errorlevel! == 0 (
	echo *******************已经存在mysql服务******************
	echo 已经存在mysql服务 >> ./install_log.txt 
	echo.
	pause
	exit
)
echo ***************不存在mysql服务，开始安装**************
echo.
echo **************开始设置系统变量MYSQL_BIN***************
echo.
SET mysqldir=%cd%
setx  /M "MYSQL_BIN"  "%mysqldir%\bin" >> ./install_log.txt
setx "PATH" "%PATH%;%pInstallDir%;%%MYSQL_BIN%%; " /M
if !errorlevel! == 0 (
	echo **************设置系统变量MYSQL_BIN成功***************
	echo.
) else ( 
	echo **************设置系统变量MYSQL_BIN失败***************
	echo 设置系统变量MYSQL_BIN失败 >> ./install_log.txt 
	echo.
	pause
	exit
)
:mysql路径
echo *****************开始设置系统变量path*****************

echo ******************开始处理my.ini文件******************
echo.
SET myinifilename=my.ini
if exist %myinifilename% (attrib -r -s -h ./my.ini)
:去除文件具有系统、只读、隐藏之类属性这些属性，使用attrib命令
cd.>./my.ini 
:清空my.ini文件
echo ******************处理my.ini文件完成******************
echo.
echo ******************开始写入mysql配置*******************
echo.
echo [mysql]>> my.ini 
echo default-character-set=utf8>> my.ini 
echo.>>my.ini 
echo [mysqld]>> my.ini 
echo port=3306>> my.ini 
echo basedir=%mysqldir:\=/%/>> my.ini 
echo datadir=%mysqldir:\=/%/data/>> my.ini 
echo character-set-server=utf8>> my.ini 
echo default-storage-engine=MyISAM>> my.ini 
echo max_connections=100>> my.ini 
echo ******************写入mysql配置完成*******************
echo.
echo ******************开始安装mysql服务*******************
echo.
cd ./bin
mysqld --install mysql >> ../install_log.txt 
if !errorlevel! equ 0 (
	echo ******************安装mysql服务成功*******************
	echo.
) else ( 
	echo ******************安装mysql服务失败*******************
	echo 安装mysql服务失败 >> ../install_log.txt 
	echo.
	pause
	exit
)
echo ******************开始启动mysql服务*******************
echo.
net start mysql >> ../install_log.txt 
if !errorlevel! equ 0 (
	echo ******************启动mysql服务成功*******************
	echo 1 >> ./is_install.txt 
	echo.
) else ( 
	echo ******************启动mysql服务失败*******************
	echo 启动mysql服务失败 >> ../install_log.txt 
	echo.
	pause
	exit
)
echo 结束时间 %date%%time% >> ../install_log.txt 
echo. >> ../install_log.txt 
echo. >> ../install_log.txt 


pause