{"id":14309,"date":"2024-01-05T22:14:34","date_gmt":"2024-01-06T05:14:34","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=14309"},"modified":"2024-01-06T01:15:52","modified_gmt":"2024-01-06T08:15:52","slug":"mysqladmin-drop-database","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-administration\/mysqladmin-drop-database\/","title":{"rendered":"mysqladmin Drop Database"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use mysqladmin drop database command to delete a database in a MySQL server.<\/p>\n\n\n\n

mysqladmin<\/a><\/strong>\u00a0is a client program that allows you to perform administrative database operations. You can use it to drop a database in a MySQL server <\/p>\n\n\n\n

The following command drops a database<\/a> from the MySQL server:<\/p>\n\n\n

mysqladmin [options] drop db_name;<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
In this command:<\/p>\n\n\n\n
    \n
  • mysqladmin<\/code> invokes the mysqladmin program from the bin directory.<\/li>\n\n\n\n
  • [options]<\/code> specifies the database connection parameters including host, user, and password.<\/li>\n\n\n\n
  • drop<\/code> instructs mysqladmin to drop a database.<\/li>\n\n\n\n
  • db_name<\/code> is the name of the database that you want to remove.<\/li>\n<\/ul>\n\n\n\n
    We’ll show you how to delete the mydb<\/code> database on the local database server:<\/p>\n\n\n\n
    First, open the Command Prompt on Windows or Terminal on Unix-like systems.<\/p>\n\n\n\n
    Second, drop the mydb<\/code> database using the mysqladmin command:<\/p>\n\n\n
     mysqladmin -u root -p drop mydb;<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    It’ll prompt you to enter the password for the root<\/code> account. <\/p>\n\n\n\n
    After entering the password, the mysqladmin program will display the following confirmation:<\/p>\n\n\n
    Dropping the database is potentially a very bad thing to do.\r\nAny data stored in the database will be destroyed.\r\n\r\nDo you really want to drop the 'mydb' database [y\/N] Y<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    Third, confirm your database deletion by entering the letter Y. The mysqladmin program will delete the mydb<\/code> database and show the following message:<\/p>\n\n\n
    Database \"mydb\" dropped<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    Behind the scenes, the mysqladmin program uses the DROP DATABASE<\/code> statement to drop the database.<\/p>\n\n\n\n
    If you don’t want the mysqladmin to confirm before dropping the database, you can use the --force<\/code> (or -f<\/code>) option.<\/p>\n\n\n\n
    For example, the following command drops the database test<\/code> without a confirmation:<\/p>\n\n\n
    mysqladmin -u root -p -f drop test;<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    This command prompts for entering the password and immediately deletes the test database. If you enter a valid password, it’ll drop the test database and return the following message:<\/p>\n\n\n
    Database \"test\"<\/span> dropped<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
    Note that if the database you want to drop does not exist, the mysqladmin program will fail and display an error. <\/p>\n\n\n\n
    For example, if you delete the mydbx<\/code> that does not exist, you’ll get the following message:<\/p>\n\n\n
    mysqladmin: DROP DATABASE mydbx failed;\r\nerror: 'Can't drop database 'mydbx'; database doesn't exist'<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Use the mysqladmin -u root -p drop db_name<\/code> command to drop a database.<\/li>\n\n\n\n
    • Use the --force<\/code> (or -f<\/code>) option in the mysqladmin command to drop a database without a confirmation.<\/li>\n<\/ul>\n
      \n\t
      \n\t\t
      Was this tutorial helpful? <\/div>\n\t\t
      \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
      \n\t\t
      \n\t\t\t
      <\/div>\n\t\t\t\n\t\t\t