Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Narrowing permissions for mysql

...

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;

...