Re: unattended silent install and initial configuration of 5.1

[Jay Alverson]

I've seen numerous errors on installs for Windows 2003 Server.

This works on XP Pro SP2, and installs MySQL Server + GUI + ODBC.

echo off
cls
echo Starting Install...

set mysql_msi="C:\Program Files\Jay\ZZDownloads\mysql-essential-6.0.7-alpha-win32.msi"
set mysql_svname=MySQL
set mysql_odbc="C:\Program Files\Jay\ZZDownloads\mysql-connector-odbc-5.1.5-win32.msi"
set mysql_gui="C:\Program Files\Jay\ZZDownloads\mysql-gui-tools-5.0-r12-win32.msi"
set mysql_datadir="C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 6.0\data"
set mysql_data2="C:\Program Files\MySQL\MySQL Server 6.0\data"
set mysql_cmd="GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;"

msiexec /i %mysql_msi% /qn INSTALLDIR="C:\Program Files\MySQL\MySQL Server 6.0\" /L* C:\MSI-MySQL-Log.txt
echo MySQL Version 6.0.7 installed...
rem md %mysql_data2%

"C:\Program Files\MySQL\MySQL Server 6.0\bin\mysqlinstanceconfig.exe" -i -q ServiceName=MySQL RootPassword=mysql ServerType=DEVELOPMENT DatabaseType=MYISAM Port=3306 RootCurrentPassword=mysql
echo MySQL Instance Configured...Service started...

rem comment next line to prevent root access from any pc...
"C:\Program Files\MySQL\MySQL Server 6.0\bin\mysql.exe" -uroot -pmysql -e %mysql_cmd%

msiexec /qn /i %mysql_odbc% /L* C:\MSI-MySQL-ODBC-Log.txt
echo ODBC Connector installed...

msiexec /qn /i %mysql_gui% /L* C:\MSI-MySQL-GUI-Log.txt
echo MySQL GUI Tools installed...

echo on

explorer "C:\Program Files\MySQL\MySQL Server 6.0\bin"

Thanks, Jay