@echo off

rem **********************************MySQL环境变量部署*****************************************
pause
cd /d %~dp0
regsvr32 IrisDevCtrl.ocx

del /F %cd%\my.ini

echo 删除完成


echo [client]>> my.ini
echo password   = 123456 >>my.ini
echo port = 3306>> my.ini

echo default-character-set=utf8>>my.ini

echo [mysqld]>> my.ini

echo collation-server=utf8_general_ci>>my.ini

echo log-error=%cd:\=\\%\\error>>my.ini

echo character_set_server=utf8>>my.ini

echo default_storage_engine=InnoDB>> my.ini

echo basedir=%cd:\=\\%\\>>my.ini

echo datadir=%cd:\=\\%\\data>> my.ini

echo innodb_data_file=ibdata1:50M;ibdata2:10M:autoextend>> my.ini

echo transaction-isolation=READ-COMMITTED>> my.ini

echo port=3306>> my.ini

echo max_allowed_packet=64M>> my.ini

echo tmp_table_size=64M>> my.ini

echo max_connections=200 >>my.ini

rem echo skip-grant-tables=1 >>my.ini

echo my.ini生成成功

cd /d %~dp0

echo 检查MySql服务是否存在

sc query |find /i "mysql" >nul 2>nul

if not errorlevel 1 (goto delexist) else goto installnew
:delexist
echo 停止已存在的服务MySQL

net stop MySQL

echo 删除已存在的服务MySQL

sc delete MySQL

echo 删除服务执行文件项

REG Delete HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL /v ImagePath /f
:installnew
echo MySql服务不存在,开始注册MySql服务

"%~dp0"\bin\mysqld.exe -install

echo 添加服务执行文件项

REG add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL /v ImagePath /t REG_EXPAND_SZ /d "%cd%\bin\MySqld.exe --defaults-file=\"%cd%\my.ini\" MySQL" /f

net start mysql

echo 修改默认root密码 
"%~dp0"bin\mysqladmin.exe -uroot password 123456 

rem **********************************数据执行*****************************************