MYSQL BASICS

#Create DB
CREATE DATABASE `my_db` CHARACTER SET utf8 COLLATE utf8_general_ci;

#Provide user access
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost'; 

GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost' IDENTIFIED BY 'password';

#Create backup
mysqldump -h host -P 3306 -uuser -p DatabaseName > PathToBackup.sql

#Restore backup
mysql -u username -p -h localhost DATA-BASE-NAME < data.sql