--Need to sudo so you'll have permissions:
--sudo mysql -u root -p
CREATE USER 'user1'@'localhost' IDENTIFIED BY 'EnterPasswordHERE';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin2'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
--To restore:
/*
--sudo mysql -u root -p
Create Database
USE it
source the input file name
** Note that the mysql database has all the logins
*/
create database x;
use x;
source <file>.sql;