Home >Database >Mysql Tutorial >How can we delete existing database using mysqladmin?

How can we delete existing database using mysqladmin?

王林
王林forward
2023-09-09 08:09:171101browse

我们如何使用 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!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete