MySQL Forums
Forum List  »  Microsoft Access

Re: Access with MySQL
Posted by: Jay Alverson
Date: September 22, 2009 08:01PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
4050
September 21, 2009 11:35PM
2402
September 22, 2009 09:54AM
2235
September 22, 2009 06:23PM
Re: Access with MySQL
2475
September 22, 2009 08:01PM
2167
September 22, 2009 09:17PM
2191
September 22, 2009 09:26PM
2139
September 23, 2009 09:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.