How can we delete existing database using mysqladmin?

We need special permissions to create or delete MySQL databases. The following is the syntax to delete a database using mysqladmin binary -

Syntax

[root@host]# mysqladmin -u root -p drop db_name
Enter password:******

Here, db_name is the name of the database we want to delete.

Example

The following is an example of deleting a database named TUTORIALS:

[root@host]# mysqladmin -u root -p drop TUTORIALS
Enter password:******

The above statement will give you a warning and confirm whether you really want to delete this database.

Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'TUTORIALS' database [y/N] y
Database "TUTORIALS" dropped

The above is the detailed content of How can we delete existing database using mysqladmin?. For more information, please follow other related articles on the PHP Chinese website!