Create a full admin

--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;

Restore a DB from a mysqldump .sql file

--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;