Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
computing:moodle [2018/11/26 00:24] – oemb1905 | computing:moodle [2019/07/06 17:54] – oemb1905 |
---|
| |
sudo mysql -u root -p | 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__'; | 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__'; | GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON __nameofdatabase__.* TO '__usernameofdatabase__'@'localhost' IDENTIFIED BY '__passwordfordatabaseuser__'; |
Think of these permissions as the most paranoid ones. You can be secure enough with less tighter permissions, both in moodledata and moodle directories (and subdirectories). | Think of these permissions as the most paranoid ones. You can be secure enough with less tighter permissions, both in moodledata and moodle directories (and subdirectories). |
| |
| This tutorial is a designated "Invariant Section" of the "Technotronic" section of Haack's Wiki as described on the [[https://jonathanhaack.com/dokuwiki/doku.php?id=start|Start Page]]. |
| |
--- //[[netcmnd@jonathanhaack.com|oemb1905]] 2018/08/04 16:45// | --- //[[netcmnd@jonathanhaack.com|oemb1905]] 2018/08/04 16:45// |