Create MySQL DB From Command Line And Import Data

CREATE USER <dbname>@localhost;

SET PASSWORD FOR <dbuser>@localhost= PASSWORD(“<db_password>”);

GRANT ALL PRIVILEGES ON <dbname>.* TO <dbuser>@localhost IDENTIFIED BY ‘<db_password>’;

FLUSH PRIVILEGES;

source <data_file>.sql;