Get info from Mysql tables

I was wondering about a way to get meta-datas from Mysql table
especially :
- table comments
- columns comments
- characters set

Thanks