Press "Enter" to skip to content

How to Select Database in MySQL Workbench?

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:

Vinish Kapoor

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *