How do I see what character set a MySQL database / table / column is?

What is the (default) charset for:

  • MySQL database
  • MySQL table
  • MySQL column