Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Narroring permissions and adding config settings for my.cfg

...

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

...

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'; 

...