Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Clarified where to find the ini file.

...

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.

Wiki Markup
ForLAMS those installing on Windows _without_ expected the installer,following pleasetwo ensureentries youto haveexist these lines in yourthe my.ini underfile in the  \[mysqld\] section:

info
Code Block
[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.