To start work in MySQL using Workbench, first, you need to select a database, so that you can execute the DML (Data Manipulation Language) statements.
Follow These Steps to Select a Database in MySQL Workbench
- Open MySQL Workbench and connect to the instance.
- Then at the left navigation panel, select the Schemas tab.
- The database schemas will display in the Schemas tab, from which you can select a database in MySQL Workbench.
- Do the right click on any of the database schema displayed and from the shortcut menu, choose Set as Default Schema option as shown in the below image:
Now the current database is set and you can execute the statements in the current database schema using MySQL Workbench.