1) bin > mysql -h hostname -u user -p password databasename < filename or bin > mysql -h hostname -u user -p databasename < filename press “enter”, then it will show “>”, then input password.
2) mysql> CREATE DATABASE databasename;
3)
mysql> CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’;
mysql> GRANT ALL PRIVILEGES ON databasename.* TO ‘username’@’localhost’
-> WITH GRANT OPTION;
mysql> CREATE USER ‘username’@’%’ IDENTIFIED BY ‘password’;
mysql> GRANT ALL PRIVILEGES ON databasename.* TO ‘username’@’%’
-> WITH GRANT OPTION;
or GRANT ALL PRIVILEGES ON databasename.* TO ‘username’@’localhost’