mysqldump –u root -p [db_name] > [backup-file.sql];
mysql –u root –p [db_name] < [backup-file.sql];
create database [db_name];
grant usage on [db__name].* to [username]@localhost identified by ‘[password]’;
grant all privileges on [db_name].* to [username]@localhost;