How to Select Database in MySQL Workbench?

How to Select Database in MySQL Workbench?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Blog
  • 1 min read

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

  1. Open MySQL Workbench and connect to the instance.
  2. Then at the left navigation panel, select the Schemas tab.
  3. The database schemas will display in the Schemas tab, from which you can select a database in MySQL Workbench.
  4. 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:

Screenshot: selecting database schema in MySQL Workbench.

Now the current database is set and you can execute the statements in the current database schema using MySQL Workbench.

See also: