MySQL Workbench - how to display relationships?

You need to open reverse engineer: Database->Reverse engineer CTRL+R

Complete the wizard. It ask about the database to connect and other simple questions.

Just click Next.

After wizard completion the MySQL Model tab will be opened. Click there ERR Diagram icon


When you edit a table in an EER model, you will have a tab named Foreign Keys that allows you to define well... the foreign keys. These foreign keys will be visible in the diagram.

You can change the settings for the displayed relationship by double clicking on the line that connects the tables.


You need to check draw line box

You need to check draw line box.


I had an issue generated a PNG with the relationship lines.

Environment

  • WorkBench version 8.0
  • MacOS Mojave 10.14.5 with Dark Theme

Solution:

Disable dark theme and regenerate the diagram then export the PNG.