All MySQL CLI stuff I ever needed

mysql.md

CREATE DATABASE `db`;

CREATE USER 'matus'@'localhost' IDENTIFIED BY 'pwd';
GRANT ALL ON db.* TO 'matus'@'localhost';

MySQL CLI for a specific DB:

$ mysql -u matus -pppassword -D db

Dump a DB:

$ mysqldump db -u matus -ppassword > dump.sql

Import dump into a specific DB:

$ mysql -u matus -pppassword -D db < dump.sql