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
PermanentImpact 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.
Leave A Comment?