Generating a ER Diagram from mysql workbench

ER_Diagram.md

Steps to create ER Diagram of an existing database using MySQL Workbench

1. Open your MySQL workbench and click on Database
2. Click on Reverse Engineer
3. Select your database connection and click on Next.
4. Click on Next.
5. Select the database schema for which you want to create the ER diagram and then click on Next.
6. After this it will retrieve objects from the selected database and check results,after the blue ticks in similar to the image below appear, click on Next.
7. Now there will be option to select objects to reverse engineer i.e. the objects for which you want to create the diagram,here I have selected all the options.After selecting objects click on Execute.
8. Click on Next.
9. Now click on Finish.
10. Once you click on the Finish button, a new tab will open in the workbench which will contain the ER diagrams of the selected objects