Syntax error How can we drop an existing database by using mysqladmin?

How can we drop an existing database by using mysqladmin?

We would need special privileges to create or to delete a MySQL database. Following is the syntax of dropping 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

Following is an example to delete a database named TUTORIALS −

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

The above statement will give you a warning and it will confirm if you really want to delete this database or not.

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
Updated on: 2020-06-20T13:43:10+05:30

169 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements