Editing Ubuntu (section)

== 6 Database and user creation ==
Create the user and database moodle will use 

* Create a new database named moodle with the utf8mb4 character set and utf8mb4_unicode_ci collation.
* Create a new MySQL user moodleuser with a password 
* Grant privileges on the moodle database to the moodleuser to allow localhost access.

 MYSQL_MOODLEUSER_PASSWORD=$(openssl rand -base64 6)
 sudo mysql -e "CREATE DATABASE moodle DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
 sudo mysql -e "CREATE USER 'moodleuser'@'localhost' IDENTIFIED BY '$MYSQL_MOODLEUSER_PASSWORD';"
 sudo mysql -e "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, CREATE TEMPORARY TABLES, DROP, INDEX, ALTER ON moodle.* TO 'moodleuser'@'localhost';"
 echo "Your Moodle user password is $MYSQL_MOODLEUSER_PASSWORD. Write this down as you will need it in a web browser install"