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