Install mycli

mycli

yaourt -S mycli

Login to mysql shell

mycli -u root -p

CREATE DATABASE menagerie;
USE menagerie

mysqladmin -u root password 'new-password'
mysqladmin -u root -h localhost password 'new-password'

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