Differences

This shows you the differences between two versions of the page.

--- computing:moodle [2019/01/14 02:19] – oemb1905
+++ computing:moodle [2019/07/06 17:54] – oemb1905
@@ Line 38: / Line 38: @@
   sudo mysql -u root -p
-  CREATE DATABASE __nameofdatabase__ DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+  CREATE DATABASE __nameofdatabase__ DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   create user '__usernameofdatabase__'@'localhost' IDENTIFIED BY '__passwordfordatabaseuser__';
   GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON __nameofdatabase__.* TO '__usernameofdatabase__'@'localhost' IDENTIFIED BY '__passwordfordatabaseuser__';

Haack's Wiki