mycli

yaourt -S mycli

mycli -u root -p

CREATE DATABASE menagerie;
USE menagerie

mysqladmin -u root password 'new-password'
mysqladmin -u root -h localhost password 'new-password'
SET PASSWORD FOR 'user'@'localhost' = PASSWORD('password');

SHOW DATABASES;
SELECT host, USER, password FROM mysql.user;
SHOW GRANTS FOR username@localhost;

SHOW TABLES