Создание базы:

> CREATE DATABASE db DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'password';

> GRANT ALL PRIVILEGES ON db.* TO 'dbuser'@'localhost';

Восстановление базы:

gunzip /tmp/dump.sql.gz
mysql -u root -p dbname < /tmp/dump.sql