Installing MySQL for LAMS

compared with
Current by Ernie Ghiglione
on Nov 13, 2018 00:01.

Key
This line was removed.
This word was removed. This word was added.
This line was added.

Changes (3)

View page history
h2. Download MySQL
h3. LAMS 3.1

{info:title=Using LAMS 3.1 }
\\
*You must use MySQL 8*
\\
\\
{info}

[Download MySQL 8|https://dev.mysql.com/downloads/mysql/]

h4. Important mysql settings in *my.cfg/my.ini*:

{noformat}
[mysqld]

## LAMS additions

explicit_defaults_for_timestamp
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
transaction-isolation=READ-COMMITTED
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
interactive_timeout = 300
wait_timeout = 300
innodb_file_per_table = 1
max_allowed_packet=32M

[mysqldump]
default-character-set=utf8mb4
hex-blob=1
single-transaction=1
quick=1

{noformat}


h4. Create DB and db user
(default settings, please change)

{noformat}
mysql> CREATE DATABASE lams DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
mysql> CREATE USER 'lams'@'localhost' IDENTIFIED BY 'lamsdemo';
mysql> GRANT ALL PRIVILEGES ON lams_nus3.* TO 'lams'@'localhost';
mysql> FLUSH PRIVILEGES;
{noformat}




h3. LAMS 2.5 and 3.0

{warning:title=Using LAMS 2.5+ on WildFly?}
\\
*You must use MySQL 5.7.10+*
\\
\\
{warning}

LAMS requires MySQL 5+. Note that *it will not work with MySQL 4 or below*.