mysql-show

show processlist;
show character set;
show create trigger tableNameInsertAfter;
show create procedure procedureName;
show create table employee \G
show databases;
show engine innodb status \G
show engine heap status \G
show grants

SHOW INDEX FROM SALES_ORDER_HEAD;

show index from employee;
show procedure status;
show triggers
show table status;
show triggers;
show variables like 'lower_case_table_names';
show variables like 'datadir';   # mysql-data-file  /var/lib/mysql
show variables like 'character%'; # for utf8 character using