To produce an entity-relation diagram (ERD) for a database on your server, you don’t have to download MySQL Workbench or login remotely. Below we show you how to create and export an ERD in cPanel phpMyAdmin, create relationships between the tables – i.e. one to one, one to many – and rearrange them as needed.
Create a Diagram in phpMyAdmin
- Log into cPanel.
- Select phpMyAdmin.
- Select the database name from the left of phpMyAdmin.
from the upper-right corner.
- From here you can rearrange tables and hover over the menu on the left to see more Designer options.
- Once you’re done making necessary changes, select Export schema from the menu.
- Select your preferred export options and Go.