How to delete a database in MySQL Workbench

We want to delete a database from a MySQL server using Workbench.

We can follow the steps bellow.

It’s preferable to make a copy of the database that we want to delete in case of failure.

In order to check the databases existing on the server we will run the command show databases;

For deleting a database we will execute the command: drop database “the name of database”;

To confirm the delete process we will execute the command show schemas; or show databases;

Permanent

Not applicable.

Not applicable;

The Drop database command is very powerful and has to be used with full awareness.