Mysql Er Diagram From Database. Reverse engineer a database. Now choose mysql dbms provide connection details more on that here and follow wizard to import schema to the repository.
Creating an entity relationship er model is to visually represent the structure of a business database where data equates to entities or objects that are linked by defined relationships expressing dependencies and requirements. Make sure place imported objects on a diagram is checked. To reverse engineer database go to menu database and choose reverse engineer.
Below is the display of mysql workbench executed.
To create the er diagram. How do i find the er diagram in mysql workbench. Export your mysql database using the structure only option. Remote connection to mysql with ssh tunnel to ubuntu 16.