How to delete a database in MySQL Workbench

Configurare noua (How To)

Situatie

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

We can follow the steps bellow.

Backup

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

Solutie

Pasi de urmat

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;

Tip solutie

Permanent

Impact colateral

Not applicable.

Plan de restaurare in caz de nefunctionare

Not applicable;

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

Voteaza

(3 din 6 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?