{"id":1448,"date":"2019-08-22T02:24:58","date_gmt":"2019-08-21T19:24:58","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1448"},"modified":"2025-04-18T15:21:41","modified_gmt":"2025-04-18T08:21:41","slug":"cara-mudah-hapus-user-account-mysql-via-terminal-linux","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/","title":{"rendered":"Cara Mudah Hapus User Account MySQL via Terminal Linux"},"content":{"rendered":"<p>MySQL memungkinkan Anda <a href=\"https:\/\/www.linuxid.net\/post\/cara-membuat-user-mysql-dan-hak-akses-mysql\/\">membuat banyak akun user<\/a> dan memberikan hak istimewa yang sesuai sehingga user dapat terhubung dan mengelola database.<\/p>\n<p>Jika akun tidak lagi diperlukan, sebaiknya menghapus hak pengguna atau menghapus akun pengguna sepenuhnya<\/p>\n<p>Tutorial ini menjelaskan cara menghapus akun pengguna MySQL \/ MariaDB.<\/p>\n<h2 id=\"drop-user-statement\" class=\"anchor\" aria-hidden=\"true\"><code>DROP USER<\/code><\/h2>\n<p>Di MySQL, Anda dapat menghapus satu atau lebih pengguna dan hak istimewa yang diberikan dengan pernyataan <code>DROP USER<\/code>. Sintaks umum dari pernyataan ini adalah sebagai berikut:<\/p>\n<pre>DROP <span class=\"n\">USER<\/span> <span class=\"p\">[<\/span><span class=\"k\">IF<\/span> <span class=\"k\">EXISTS<\/span><span class=\"p\">]<\/span> <span class=\"n\">USER_ACCOUNT<\/span> <span class=\"p\">[,<\/span> <span class=\"n\">USER_ACCOUNT<\/span><span class=\"p\">]<\/span> <span class=\"p\">...<\/span><\/pre>\n<p>Misalnya untuk menghapus login akun pengguna <code>brian@localhost<\/code> ke MYSQL shell dan jalankan:<\/p>\n<pre>DROP <span class=\"n\">USER<\/span> <span class=\"s1\">'brian@localhost'<\/span><span class=\"p\">;<\/span><\/pre>\n<p>Jika berhasil, perintah akan kembali:<\/p>\n<pre>Query OK, 0 rows affected (0.00 sec)<\/pre>\n<p>Untuk menghapus beberapa akun dalam satu perintah, jalankan pernyataan <code>DROP USER<\/code> diikuti dengan pengguna yang ingin Anda hapus dipisahkan dengan spasi:<\/p>\n<pre>DROP USER 'brian@localhost' 'any@localhost';<\/pre>\n<p>Jika Anda mencoba untuk drop user yang tidak ada dan statement<code>IF EXISTS<\/code>tidak digunakan, perintah akan menampilkan output error.<\/p>\n<p>Jika user yang Anda coba hapus saat ini masuk, sesi pengguna tidak akan ditutup dan pengguna akan dapat menjalankan kueri hingga sesi berakhir. Setelah sesi ditutup, pengguna akan dihapus dan tidak lagi dapat masuk ke server MySQL.<\/p>\n<p>Database dan objek yang dibuat oleh pengguna tidak dihapus secara otomatis.<\/p>\n<h2>Menghapus Akun Pengguna MySQL<\/h2>\n<p>Bagian ini adalah petunjuk langkah demi langkah tentang cara membuat daftar dan menghapus akun pengguna MySQL.<\/p>\n<p>Pertama, masuk ke shell MySQL dengan root atau pengguna administratif lain. Untuk melakukannya ketik perintah berikut:<\/p>\n<pre>sudo mysql<\/pre>\n<p>Jika Anda menggunakan plugin native MySQL authentication untuk masuk sebagai root jalankan perintah di bawah ini dan masukkan kata sandi ketika diminta:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">mysql -u root -p<\/pre>\n<p>Perintah di bawah ini dijalankan di dalam shell MySQL.<\/p>\n<p>MySQL menyimpan informasi tentang pengguna, di tabel <code>user<\/code> di database <code>mysql<\/code>. Gunakan statement <code>SELECT<\/code>\u00a0untuk mendapatkan <a href=\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/\">daftar semua akun user<\/a> MySQL:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT User, Host FROM mysql.user;<\/pre>\n<p>Outputnya akan terlihat seperti ini:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">+------------------+-----------+&#13;\n| user  | host      |&#13;\n+------------------+-----------+&#13;\n| root  | localhost |&#13;\n| luke  | %         |&#13;\n| raka  | localhost |&#13;\n| raka  | 10.10.8.8 |&#13;\n| hack33r          | localhost |&#13;\n+------------------+-----------+&#13;\n5 rows in set (0.00 sec)<\/pre>\n<p>Di MySQL, akun pengguna terdiri dari nama user dan bagian hostname.\u00a0<code>raka@localhost<\/code> dan <code><a href=\"https:\/\/www.linuxid.net\/cdn-cgi\/l\/email-protection\" class=\"__cf_email__\" data-cfemail=\"e496858f85a4d5d4cad5d4cadccadc\">[email\u00a0protected]<\/a><\/code> adalah akun user yang berbeda.<\/p>\n<p>Katakanlah akun pengguna walaha@localhost tidak lagi diperlukan dan kami ingin menghapusnya.<\/p>\n<p>Untuk menghapus user, jalankan<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">DROP USER 'hack33r'@'localhost'<\/pre>\n<pre>Query OK, 0 rows affected (0.00 sec)<\/pre>\n<p>Perintah akan menghapus akun user dan hak istimewanya.<\/p>\n<p>Sekarang user dihapus, Anda mungkin juga ingin <a href=\"https:\/\/www.linuxid.net\/post\/cara-menghapus-database-mysql-di-linux-terminal\/\">menghapus database<\/a> yang terkait dengan user yang telah di hapus tersebut.<\/p>\n<h2>Kesimpulan<\/h2>\n<p>Untuk menghapus akun pengguna MySQL, gunakan pernyataan <code>DROP USER<\/code> diikuti dengan nama pengguna yang ingin Anda hapus.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL memungkinkan Anda membuat banyak akun user dan memberikan hak istimewa yang sesuai sehingga user&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1449,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[99,41,166],"class_list":["post-1448","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mariadb","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 Mudah Hapus User Account MySQL via Terminal Linux - 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:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mudah Hapus User Account MySQL via Terminal Linux - Linuxid\" \/>\n<meta property=\"og:description\" content=\"MySQL memungkinkan Anda membuat banyak akun user dan memberikan hak istimewa yang sesuai sehingga user&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-21T19:24:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T08:21:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Mudah-Hapus-User-Account-MySQL-via-Terminal-Linux.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"883\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\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:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/\",\"url\":\"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/\",\"name\":\"Cara Mudah Hapus User Account MySQL via Terminal Linux - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Mudah-Hapus-User-Account-MySQL-via-Terminal-Linux.jpg\",\"datePublished\":\"2019-08-21T19:24:58+00:00\",\"dateModified\":\"2025-04-18T08:21:41+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Mudah-Hapus-User-Account-MySQL-via-Terminal-Linux.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Mudah-Hapus-User-Account-MySQL-via-Terminal-Linux.jpg\",\"width\":883,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Mudah Hapus User Account MySQL via Terminal Linux\"}]},{\"@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 Mudah Hapus User Account MySQL via Terminal Linux - 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:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mudah Hapus User Account MySQL via Terminal Linux - Linuxid","og_description":"MySQL memungkinkan Anda membuat banyak akun user dan memberikan hak istimewa yang sesuai sehingga user&hellip;","og_url":"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/","og_site_name":"Linuxid","article_published_time":"2019-08-21T19:24:58+00:00","article_modified_time":"2025-04-18T08:21:41+00:00","og_image":[{"width":883,"height":530,"url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Mudah-Hapus-User-Account-MySQL-via-Terminal-Linux.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:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/","url":"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/","name":"Cara Mudah Hapus User Account MySQL via Terminal Linux - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Mudah-Hapus-User-Account-MySQL-via-Terminal-Linux.jpg","datePublished":"2019-08-21T19:24:58+00:00","dateModified":"2025-04-18T08:21:41+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Mudah-Hapus-User-Account-MySQL-via-Terminal-Linux.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Mudah-Hapus-User-Account-MySQL-via-Terminal-Linux.jpg","width":883,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxid.net\/post\/cara-mudah-hapus-user-account-mysql-via-terminal-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Mudah Hapus User Account MySQL via Terminal Linux"}]},{"@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\/1448","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=1448"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1448\/revisions"}],"predecessor-version":[{"id":2849,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1448\/revisions\/2849"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1449"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}