Mysql

mysql --user=$USERNAME --password=$PASSWORD

Useful commands

mysql --user=user -p

CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';

CREATE DATABASE database;

GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost' WITH GRANT OPTION;

REVOKE ALL PRIVILEGES ON *.* FROM 'user'@'localhost';

DROP DATABASE db;

DROP USER user;

Import a *.sql backup

mysqlimport --user=user -p -D wiki_old mediawiki.sql