MySQL create user

To create user:


CREATE USER 'username'@'host' IDENTIFIED BY 'password';

To grant all privileges to user on a specific database:

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'host';


MySQL import dump

To import database from a dumped sql file:

• Login to mysql


• Create database with the specific name:
  
  
create database database_name;

  


• Exit mysql.


• Import the contents of the database from a file:
  
mysql -u user -p database_name < database_dump.sql