How to study/analysis a MySQL DB tables relationships?

I'm given a MySQL DB that contain 108 tables. Is there a way or tool (software) to be able to see how these tables are connected (hopefully in a visual way) so I would be able to understand the usage of each table and how everything is working together. I'm accessing them through something called "MySQL Tools" -> "MySQL Admi开发者_StackOverflow社区nistrator" with "Read Only" privileges.

Tables are all using InnoDB engine.

*I'm using Mac

What you want is an ERD generator for MySQL. Do a google search on 'MySQL ERD' and plenty of free options pop up. I have not used this, however, I have heard decent things about DBDesigner

this will only happen "automatically" if the database is using foreign keys. in my experience, most mysql-based applications do not so you might be out of luck there.

DB Visualizer
MySQL Workbench