Windows配置MySQL和程序

环境：Windows7   64

使用MySQL的VC程序

@echo off
SET DESTDISKVOL="D:"
SET DESTFOLDER=%DESTDISKVOL%\membermanagement
SET CURFOLDER=%~dp0
echo == 复制文件

move membermanagement %DESTFOLDER%\
cd mysql-5.6.16-win32\mysql-5.6.16-win32
copy my-default.ini my.ini
cd ..\..\
move mm %DESTFOLDER%\mm
move mysql-5.6.16-win32\mysql-5.6.16-win32 %DESTFOLDER%\mysql-5.6.16-win32

echo == 安装ODBC
mkdir "%DESTFOLDER%\mysql-5.6.16-win32\Connector ODBC 5.2"
copy mysql-connector-odbc-noinstall-5.2.6-win32\mysql-connector-odbc-noinstall-5.2.6-win32\lib\*.* "%DESTFOLDER%\mysql-5.6.16-win32\Connector ODBC 5.2\"
copy mysql-connector-odbc-noinstall-5.2.6-win32\mysql-connector-odbc-noinstall-5.2.6-win32\bin\*.exe "%DESTFOLDER%\mysql-5.6.16-win32\Connector ODBC 5.2\"
echo 配置ODBC
echo == 配置环境变量
reg add "HKLM\System\CurrentControlSet\Control\Session Manager\Environment" /v PATH /t REG_EXPAND_SZ /d "%DESTFOLDER%\mysql-5.6.16-win32\bin;%PATH%" /f

echo == 配置系统服务
cd %DESTFOLDER%\mysql-5.6.16-win32\bin
mysqld --install
rem # sc create MySQL binPath= %DESTFOLDER%\mysql-5.6.16-win32\bin\mysqld.exe start= auto DisplayName= mysqlsctt

echo == 启动数据库管理系统
mysqld

echo == 初始化数据库


echo == 创建快捷方式
SET MMPATH=%DESTFOLDER%\mm\mm1.exe
SET TOMM="%USERPROFILE%\DeskTop\mm.url"
echo [InternetShortcut] >> %TOMM%
echo URL="%MMPATH%" >> %TOMM%
echo IconIndex=0 >> %TOMM%
echo IconFile=%MMPATH% >> %TOMM%