- Create database and user
create database my_database;
create user 'myUser'@'localhost' identified by 'myPassword';
GRANT ALL PRIVILEGES ON my_database.* TO 'myUser'@'localhost';
- Import dump
mysql -u myUser -p my_database < dump.sql
create database my_database;
create user 'myUser'@'localhost' identified by 'myPassword';
GRANT ALL PRIVILEGES ON my_database.* TO 'myUser'@'localhost';
mysql -u myUser -p my_database < dump.sql