Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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, or my.cnf. 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 you are using Linux/Ubuntu/Debian, you can probably find the file in /etc/mysql/my.cnf.

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.

Using a bundled MySQL

If you are using a bundled MySQL instance like for instance WAMP 2.0 or XAMPP, there are special steps you must follow.

XAMPP

XAMPP Website: http://www.apachefriends.org/en/xampp.html

If you are installing LAMS onto MySQL which is part of XAMPP, then you need to make sure that the my.ini file exists BEFORE you start installing LAMS. The file is likely to be in your windows directory. If it is not, run your XAMPP control panel and click the "Admin" button next to mysql. This should start the WinMySQLadmin window - if a my.ini file doesn't exist it should set one up for you automatically. If this is the first time you have run WinMySQLadmin, it asks for a username and password. I left both fields blank and clicked Cancel, and it created the my.ini file for me anyway. I'm not sure what setting a username and password here does as I set it once and it never seemed to ask me for it every again!

If the my.ini file doesn't exist before running the installer, you will be warned that the installer can't find the my.ini file and you will neeed to add the transaction-isolation setting manually using WinMySQLadmin (or a text editor).

WAMP

WAMP Website: http://www.wampserver.com/

LAMS has successfully been installed using WAMP mysql on Windows XP SP2 using the following steps.

1) Install WAMP
2) Open MySQL command line and type the following commands

use mysql;

CREATE TABLE 'servers' (

'Server_name' char(64) NOT NULL,

'Host' char(64) NOT NULL,

'Db' char(64) NOT NULL,

'Username' char(64) NOT NULL,

'Password' char(64) NOT NULL,

'Port' int(4) DEFAULT NULL,

'Socket' char(64) DEFAULT NULL,

'Wrapper' char(64) NOT NULL,

'Owner' char(64) NOT NULL,

PRIMARY KEY ('Server_name')

) ENGINE=InnoDB DEFAULT CHARSET=utf8

COMMENT='MySQL Foreign Servers table';

3) Install LAMS using PORT 8180, and MYSQL DIR: <path>\wamp\bin\mysql\mysql5.1.30

4) Restart the machine

5) There have been some issues with the start script using WAMP MySQL, so if you find that the start script does not work, you can manually start LAMS by going into the control panel/administative tools/services and starting the LAMS service, or you can start it on the command line using the following command "sc start LAMSv2"

  • No labels