Moodle – Upgrade version with Git from 3.3-3.*

First Step: 

 git remote add upstream https://github.com/moodle/moodle.git

Second Step: 

vim update.sh 
#!/bin/bash
git fetch upstream
for BRANCH in MOODLE_{31..37}_STABLE master;
do
git push origin refs/remotes/upstream/$BRANCH:refs/heads/$BRANCH
done

Source: https://docs.moodle.org/dev/Git_for_developers

Moodle – Mysql query initiate new DB for Moodle

How to quickly create Data Base for Moodle Instance via CLI Mode (Less secure Not for Production Mode)

run: CREATE DATABASE moodle DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
//mysql 5.7
GRANT ALL PRIVILEGES ON moodle.* to 'youredbusername'@'localhost' identified by 'yourepassword'; 
//mysql 8
//Create User
CREATE USER 'moodle'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourepassword';

//grand all permission  
GRANT ALL PRIVILEGES ON moodle.* TO 'moodle'@'localhost';