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'

mysql> SHOW DATABASES;

mysql> select host, user, password from mysql.user; mysql> SHOW GRANTS FOR username@localhost;