Installing MySQL

Install mysql - in instance config, choose detailed config and install as Server machine.

• choose "Transacitonal database only.
• use default for inndb tablespace settings.
• use default - Decision support (DSS)/OLAP
• use deafult (enable tcp/ip networking on port 3306, Enable strict mode
• Use default - Standard character set
• Install as windows service
• Install as windows service, choose "Launch mysql server automatically"
• Include bin dir in windows path
• Modify Security settings: enter ZEPRS db admin password, check "Enable root access from remote machines
• When it says it's time to write the config files and start the install, do not be alarmed if a message comes up saying that it wa sunable to start the service. Wait a few moments, click retry. If it doesn't work, try again. It took me 3 times before it work. If it just does not work, it is fine to skip that step.
• Shutdown mysql, and edit my.ini file. Add old_passwords=1

Install the MySQL GUI tools

• Choose complete install.