MySQL, seeing foreign keys

I am tasked with understanding a MySQL database on a Linux box. The database is not that complicated, but how do I see foreign key relationships? I don't see them when I use "show columns" or "describe". So far I've been using only console commands; is there a way to do this through console or do I have to use MySQL workbench and generate the EER diagram?

I am not super experienced with SQL databases but I do use MySQL and Workbench. I am trying to understand exactly what you are trying to do; is it matching entries across tables by comparing keys?