List databases

SHOW DATABASES;

List tables in a database

USE database_name;
SHOW TABLES;

List users in a database

select Host, User from mysql.user;