Listar base de datos en mysql

/* lists databases */
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;

/* lists tables */
SELECT * FROM INFORMATION_SCHEMA.TABLES;
/* also */
use database x;
show tables;

/* lists columns */
SELECT * FROM INFORMATION_SCHEMA.COLUMNS;