Download MySQL

LAMS 2.0 requires MySQL 5.0. Note that it will not work with MySQL 4 or below.

You can download MySQL 5.0 for Windows from the MySQL downloads website. The MySQL Essentials package is about 17 MB in size.

Installing and Configuring MySQL

For those interested, you can find out more about installing and configuring MySQL from the MySQL chapter on Windows installation. For LAMS usage, the defaults in the installer should be fine.

LAMS expected the following two entries to exist in the my.ini file in the  \[mysqld\] section

[mysqld]
...
transaction-isolation=READ-COMMITTED
...
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

For those installing on Windows without the installer, please ensure you have these lines in your my.ini. This file can usually be found in either your MySQL Server directory (e.g. C:\Program Files\MySQL Server 5.0) or in your Windows directory (C:\Windows).

If installing MySQL using the MySQL Windows installer the sql-mode will already be set for you. In this case the transaction-isolation setting will be configured by the LAMS Windows installer, so you don't have to worry about editing the my.ini file.

If you are installing LAMS onto MySQL which is part of XAMPP, you will should set up the transaction-isolation setting. The my.ini file is likely to be in your windows directory.