mysqldump -u root -p <database> > /path/to/file.sql
mysql -u root -p <database> < /path/to/file.sql
CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
GRANT ALL PRIVILEGES ON <database>.* TO '<user>'@'localhost';
mysqldump -u root -p <database> > /path/to/file.sql
mysql -u root -p <database> < /path/to/file.sql
CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
GRANT ALL PRIVILEGES ON <database>.* TO '<user>'@'localhost';