{"id":1774,"date":"2025-04-18T16:08:13","date_gmt":"2025-04-18T09:08:13","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1774"},"modified":"2025-04-18T16:08:13","modified_gmt":"2025-04-18T09:08:13","slug":"cara-menghapus-database-mysql-di-linux-terminal","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/","title":{"rendered":"Cara Menghapus Database MySQL di Linux Terminal"},"content":{"rendered":"<p>MySQL adalah sistem manajemen basis data relasional open-source yang paling populer.<\/p>\n<p>Menghapus database MySQL cukup mudah, cukup dengan menjalankan satu perintah. Perlu di perhatikan bahwa ini adalah tindakan yang tidak dapat dibalik dan harus dijalankan dengan extra hati-hati. Pastikan Anda tidak menghapus database yang salah, karena begitu menghapus database di MySQL, data yang hilang tidak akan kembali.<\/p>\n<p>Tutorial ini menjelaskan cara menghapus (delete atau drop) untuk database MySQL atau MariaDB melalui baris perintah.<\/p>\n<h2>Sebelum Mulai<\/h2>\n<p>Semua perintah dijalankan sebagai pengguna administratif (hak istimewa (<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/privileges-provided.html\" target=\"_blank\" rel=\"noopener\">privilege<\/a>) minimum yang diperlukan untuk menghapus database adalah perintah\u00a0<code>DROP<\/code>) atau dengan akun root.<\/p>\n<p>Untuk mengakses konsol MySQL, ketik perintah berikut dan masukkan kata sandi pengguna root MySQL Anda saat diminta:<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>Jika Anda belum menetapkan kata sandi untuk pengguna root MySQL Anda, Anda dapat menghilangkan flag<code>-p<\/code>.<\/p>\n<p>Jika Anda perlu mengubah kata sandi root MySQL Anda, kemudian ikuti tutorial ini tentang <a href=\"https:\/\/www.linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/\">mengatur ulang kata sandi root MySQL<\/a> melalui baris perintah.<\/p>\n<h2>Daftar Semua Database MySQL<\/h2>\n<p>Sebelum menjatuhkan basis data, Anda mungkin ingin melihat daftar semua basis data yang Anda buat. Untuk melakukannya dari dalam shell MySQL, jalankan perintah berikut:<\/p>\n<pre>SHOW DATABASES;<\/pre>\n<p>Perintah di atas akan mencetak daftar semua database di server. Outputnya sama dengan ini:<\/p>\n<pre>+--------------------+&#13;\n| Database|&#13;\n+--------------------+&#13;\n| information_schema |&#13;\n| database_name      |&#13;\n| mysql   |&#13;\n| performance_schema |&#13;\n| test    |&#13;\n+--------------------+&#13;\n5 rows in set (0.00 sec).<\/pre>\n<h2>Hapus Database di MySQL<\/h2>\n<p>Menghapus MySQL database hanya menjalankan satu perintah. Menghapus Database di MySQL adalah tindakan yang tidak dapat dibalik dan harus dijalankan dengan hati-hati. Pastikan Anda tidak menghapus database yang salah, karena begitu Anda menghapus database itu tidak dapat dipulihkan.<\/p>\n<p>Itu selalu merupakan ide yang baik untuk membuat <a href=\"https:\/\/www.linuxid.net\/post\/tutorial-mysqldump-untuk-backup-dan-restore-database-mysql\">backup dari database <\/a>sebelum menjalankan query drop.\u00a0Untuk menghapus database, ketikkan perintah berikut ini, di mana <code><code>nama_db<\/code><\/code> adalah nama database yang ingin Anda hapus:<\/p>\n<pre>DROP DATABASE <code>nama_db<\/code>;<\/pre>\n<pre>Query OK, 1 row affected (0.00 sec)<\/pre>\n<p>Jika Anda mencoba menghapus database yang tidak ada, Anda akan melihat pesan kesalahan berikut:<\/p>\n<pre>ERROR 1008 (HY000): Can't drop database '<code>nama_db<\/code>'; database doesn't exist<\/pre>\n<p>Untuk menghindari melihat kesalahan seperti di atas, gunakan perintah berikut sebagai gantinya:<\/p>\n<pre>DROP DATABASE IF EXISTS <code>nama_db<\/code>;<\/pre>\n<pre>Query OK, 1 row affected, 1 warning (0.00 sec)<\/pre>\n<p>Dalam output di atas, <code>Query OK<\/code> berarti kueri berhasil, dan <code>1 warning<\/code>\u00a0yang memberi tahu kita bahwa database tidak ada dan tidak ada database yang dihapus.<\/p>\n<p>Di Linux, database MySQL dan nama tabel adalah <em>case sensitive<\/em> (peka huruf besar-kecil).<\/p>\n<h2>Hapus Database MySQL dengan mysqladmin<\/h2>\n<p>Anda juga dapat menghapus database MySQL dari terminal Linux dengan menggunakan utilitas <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/mysqladmin.html\" target=\"_blank\" rel=\"noopener\">mysqladmin<\/a>.<\/p>\n<p>Misalnya, untuk menghapus database bernama <code>nama_db<\/code>, ketikkan perintah berikut dan masukkan kata sandi pengguna root MySQL Anda saat diminta:<\/p>\n<pre>mysqladmin -u root -p drop <code>nama_db<\/code><\/pre>\n<h2>Kesimpulan<\/h2>\n<p>Anda telah belajar cara menghapus database MySQL.<\/p>\n<p>Lihat juga panduan lain tentang mengolah dan mengatur database :<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL adalah sistem manajemen basis data relasional open-source yang paling populer. Menghapus database MySQL cukup&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1775,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[41,166],"class_list":["post-1774","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menghapus Database MySQL di Linux Terminal - Linuxid<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Database MySQL di Linux Terminal - Linuxid\" \/>\n<meta property=\"og:description\" content=\"MySQL adalah sistem manajemen basis data relasional open-source yang paling populer. Menghapus database MySQL cukup&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-18T09:08:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menghapus-Database-MySQL-di-Linux-Terminal.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"952\" \/>\n\t<meta property=\"og:image:height\" content=\"370\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"xsand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"xsand\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/\",\"url\":\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/\",\"name\":\"Cara Menghapus Database MySQL di Linux Terminal - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menghapus-Database-MySQL-di-Linux-Terminal.jpg\",\"datePublished\":\"2025-04-18T09:08:13+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menghapus-Database-MySQL-di-Linux-Terminal.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menghapus-Database-MySQL-di-Linux-Terminal.jpg\",\"width\":952,\"height\":370},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Menghapus Database MySQL di Linux Terminal\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/linuxid.net\/post\/#website\",\"url\":\"https:\/\/linuxid.net\/post\/\",\"name\":\"Linuxid\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/linuxid.net\/post\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\",\"name\":\"xsand\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"caption\":\"xsand\"},\"url\":\"https:\/\/www.linuxid.net\/post\/author\/xsand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menghapus Database MySQL di Linux Terminal - Linuxid","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Database MySQL di Linux Terminal - Linuxid","og_description":"MySQL adalah sistem manajemen basis data relasional open-source yang paling populer. Menghapus database MySQL cukup&hellip;","og_url":"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/","og_site_name":"Linuxid","article_published_time":"2025-04-18T09:08:13+00:00","og_image":[{"width":952,"height":370,"url":"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menghapus-Database-MySQL-di-Linux-Terminal.jpg","type":"image\/jpeg"}],"author":"xsand","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"xsand","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/","url":"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/","name":"Cara Menghapus Database MySQL di Linux Terminal - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menghapus-Database-MySQL-di-Linux-Terminal.jpg","datePublished":"2025-04-18T09:08:13+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menghapus-Database-MySQL-di-Linux-Terminal.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menghapus-Database-MySQL-di-Linux-Terminal.jpg","width":952,"height":370},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Menghapus Database MySQL di Linux Terminal"}]},{"@type":"WebSite","@id":"https:\/\/linuxid.net\/post\/#website","url":"https:\/\/linuxid.net\/post\/","name":"Linuxid","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxid.net\/post\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79","name":"xsand","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","caption":"xsand"},"url":"https:\/\/www.linuxid.net\/post\/author\/xsand\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/comments?post=1774"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1774\/revisions"}],"predecessor-version":[{"id":3095,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1774\/revisions\/3095"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1775"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}