1) Download and install MySql workbench in your system.
2) Open MySql workbench
3) Confirm 'MySQL service' (MySQL80) is running.
Open Windows tray and click MySql Notifier
4)Open the configured local instance (localhost:3306 - root/root)
5) Select the 'Schemas' and right click on the 'schemas pane' and select 'Create Schemas' option.
6) Enter the schema name (case sensitive - 1st letter should be small ) and click apply.
Click 'Apply'.
Click 'Finish'.
7) Created schema will be loaded in schema list.
Expand the schema >> select table >> Right click on the table >> Select 'Create table'
Note:
if you are dealing with Spring boot - JPA/Hibernate annotation in your source code. No need to create table manually from MySql workbench neither those annotation will take care of this process.
8)To load the table data on worksheet
Expand the table >> select the table >> Right click on the table >> Click option 'Select Rows - Limit 1000'
Previous session: Click to know - How To use Postman tool?
Next session: Click to know - Basic annotations for Spring Boot
Context page: Click here
Home page: Click here
Thanks, I hope you enjoyed this session !!!.
-Somasundar Kanakaraj