No problem.
MSI are available at...
http://dev.mysql.com/downloads/mysql/5.1.html#win32
I've posted the .BAT file several times. This is for MySQL version 6
but you can use any version you want. Just change the path/filename
of the .msi files. Obviously if the paths are different on the pcs
you'll have to change those as well.
This should get you started. So far everyone's said they work. Haven't
tried Vista.
Here's the code:
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"
The user ROOT has the password MYSQL after the install.
You can then create .SQL files to add other accounts and set passwords.
Also create other .SQL files to build your database. Then you can run
them as part of the .BAT file to do everything at once.
Let me know if you have any questions.
>
Thanks, Jay