Install mycli mycli <code bash> yaourt -S mycli </code> 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;