MOODLE Step-by-step Installation Guide for Ubuntu

參考網址

https://docs.moodle.org/28/en/Step-by-step_Installation_Guide_for_Ubuntu#Step_3:_Install_Additional_Software

我自己的

CREATE DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

create user moodle@localhost IDENTIFIED BY '密碼';

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO moodle@localhost IDENTIFIED BY '密碼'

GRANT all  privileges ON moodle.* TO moodle@localhost IDENTIFIED BY '密碼';

flush privileges;