Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

No Format
[mysqld] 

## LAMS additions

explicit_defaults_for_timestamp
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
transaction-isolation=READ-COMMITTED
sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_AUTOZERO_CREATEIN_USERDATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,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

...

No Format
mysql> CREATE DATABASE lams DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
mysql> CREATE USER 'lams'@'localhost' IDENTIFIED BY 'lamsdemo'; 
mysql> GRANT ALL PRIVILEGES SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON lams_nus3.* TO 'lams'@'localhost';
mysql> FLUSH PRIVILEGES;

...

Code Block
mysql> DROP DATABASE IF EXISTS lams; 
mysql> CREATE DATABASE lams DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
mysql> GRANT ALL PRIVILEGES SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON lams.* TO lams@localhost IDENTIFIED BY 'lamsdemo'; 

...

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 MarkupLAMS expected the following two entries to exist in the my.ini file in the  \in the  [mysqld\] section

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

...