MySQL

Backup database

mysqldump –u root -p [db_name] > [backup-file.sql];

Run SQL script (a.k.a. restore database)

mysql –u root –p [db_name] < [backup-file.sql];

Create Database

create database [db_name];

Create User and Grant Access to Database

grant usage on [db__name].* to [username]@localhost identified by ‘[password]’;
grant all privileges on [db_name].* to [username]@localhost;