{"id":1772,"date":"2025-04-18T16:08:13","date_gmt":"2025-04-18T09:08:13","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1772"},"modified":"2025-04-18T16:08:13","modified_gmt":"2025-04-18T09:08:13","slug":"cara-menampilkan-semua-user-di-mysql","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/","title":{"rendered":"Cara Menampilkan Semua User di MySQL"},"content":{"rendered":"

Kadang kita ingin melihat siapa saja yang memiliki hak akses super administrator, atau bisa jadi baru saja terjadi bencana seperti pembobolan data? dan kemudian kita ingin melihat atau meneliti siapa saja yang memiliki hak akses di MySQL server.<\/p>\n

Jika Anda melihat panduan kami tentang dasar manajemen MySQL di baris perintah, terdapat perintah untuk menampilkan database dan tabel, tetapi tidak ada perintah MySQL untuk \u201cmenampilkan pengguna\u201d.<\/p>\n

Tutorial ini menjelaskan cara membuat daftar semua akun pengguna di server database MySQL melalui baris perintah.<\/p>\n

Sebelum mulai<\/h2>\n

\u00a0<\/p>\n

Sebelum Anda mulai dengan tutorial ini, kami mengasumsikan bahwa Anda sudah menginstal MySQL server atau MariaDB di sistem Anda. Jika belum, Anda dapat menginstalnya dengan mudah dengan mengikuti salah satu tutorial di bawah ini:<\/p>\n

Semua perintah akan dieksekusi di dalam shell MySQL sebagai pengguna root.<\/p>\n

Untuk mengakses shell MySQL ketik perintah berikut dan masukkan kata sandi pengguna root MySQL Anda ketika diminta:<\/p>\n

mysql -u root -p<\/pre>\n
Jika Anda belum menetapkan kata sandi untuk pengguna root MySQL, Anda dapat menghilangkan flag-p<\/code>.<\/p>\n
Jika lupa kata sandi root MySQL, Anda dapat meresetnya dengan mengikuti instruksi ini<\/a>.<\/p>\n
Tampilkan User MySQL<\/h2>\n
MySQL menyimpan informasi tentang pengguna, dalam tabel bernama user<\/code>\u00a0di database mysql<\/code>\u00a0. Untuk mendapatkan daftar semua akun pengguna MySQL kita dapat menggunakan pernyataan SELECT<\/code>\u00a0untuk mengambil semua baris dari tabel mysql.users<\/code>:<\/p>\n
SELECT User, Host FROM mysql.user;<\/pre>\n
Outputnya akan terlihat seperti di bawah ini (tabel merupakan contoh data):<\/p>\n

\n+------------------+-----------+
\n| user  | host      |
\n+------------------+-----------+
\n| root  | localhost |
\n| admn  | %         |
\n| yuli  | %         |
\n| babba | 10.10.0.3 |
\n| babba | 10.10.0.5 |
\n| chikazush        | localhost |
\n| lala  | localhost |
\n| badu  | localhost |
\n+------------------+-----------+
\n8 rows in set (0.00 sec)<\/pre>\n
Perintah di atas hanya menampilkan dua kolom dari tabel mysql.user<\/code> (User<\/code>\u00a0dan Host<\/code>), Tabel ini berisi lebih dari 40 kolom seperti Password<\/code>,\u00a0Select_priv<\/code>,\u00a0Update_priv<\/code>\u2026 dll.<\/p>\n
Akun pengguna di MySQL terdiri dari nama pengguna dan host name.\u00a0Anda dapat menggunakan\u00a0pernyataan desc mysql.user;<\/code>\u00a0untuk menampilkan informasi tentang masing-masing kolom tabel. Setelah Anda tahu nama kolom, jalankan kueri terhadap data yang dipilih.<\/p>\n
Misalnya untuk mendapatkan daftar semua akun pengguna MySQL termasuk informasi tentang kata sandi dan apakah kata sandi itu aktif atau expired (kedaluarsa), Anda dapat menggunakan kueri berikut:<\/p>\n
SELECT User, Host, Password, password_expired FROM mysql.user;<\/pre>\n
+----------------+-----------+-------------------------------------------+------------------+
\n| User| Host      | Password | password_expired |
\n+----------------+-----------+-------------------------------------------+------------------+
\n| root| localhost |          | N     |
\n| admn| %         | *ADC3B5B72617732CD6320A2DA976258E149A7EC8 | N     |
\n| yuli| %         | *9550E004546348198A143A115550E1262209FB6F | N     |
\n| babba          | 10.10.0.6 | *F91C86B445B945C083B61A05FF6E197560D187EC | Y     |
\n| babba          | 10.10.0.9 |          | Y     |
\n| chikazush      | localhost | *17F2B1E48058294841AD66772BEBB7E6E6A005AF | N     |
\n| lala| localhost | *74409C8DB64AC1A6829D801915981C46EDBFC64A | N     |
\n| badu | localhost | *7B3022FCAEC6534CE67C68322D8AF0C240D95745 | N     |
\n+----------------+-----------+-------------------------------------------+------------------+
\n8 rows in set (0.00 sec)<\/pre>\n
Kesimpulan<\/h2>\n
Dalam tutorial ini, kami telah menunjukkan kepada Anda cara mendapatkan daftar semua akun pengguna MySQL dengan mengambil data dari tabel pengguna di database mysql.<\/p>\n
Lihat juga panduan lain tentang mengolah dan mengatur database :<\/p>\n","protected":false},"excerpt":{"rendered":"
Kadang kita ingin melihat siapa saja yang memiliki hak akses super administrator, atau bisa jadi…<\/p>\n","protected":false},"author":2,"featured_media":1773,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[99,41,166],"class_list":["post-1772","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mariadb","tag-mysql","tag-sql"],"yoast_head":"\nCara Menampilkan Semua User di MySQL - 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-menampilkan-semua-user-di-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menampilkan Semua User di MySQL - Linuxid\" \/>\n<meta property=\"og:description\" content=\"Kadang kita ingin melihat siapa saja yang memiliki hak akses super administrator, atau bisa jadi…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/\" \/>\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:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-User-di-MySQL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\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-menampilkan-semua-user-di-mysql\/\",\"url\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/\",\"name\":\"Cara Menampilkan Semua User di MySQL - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-User-di-MySQL.jpg\",\"datePublished\":\"2025-04-18T09:08:13+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-User-di-MySQL.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-User-di-MySQL.jpg\",\"width\":1000,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Menampilkan Semua User di MySQL\"}]},{\"@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 Menampilkan Semua User di MySQL - 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-menampilkan-semua-user-di-mysql\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menampilkan Semua User di MySQL - Linuxid","og_description":"Kadang kita ingin melihat siapa saja yang memiliki hak akses super administrator, atau bisa jadi…","og_url":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/","og_site_name":"Linuxid","article_published_time":"2025-04-18T09:08:13+00:00","og_image":[{"width":1000,"height":530,"url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-User-di-MySQL.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-menampilkan-semua-user-di-mysql\/","url":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/","name":"Cara Menampilkan Semua User di MySQL - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-User-di-MySQL.jpg","datePublished":"2025-04-18T09:08:13+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-User-di-MySQL.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-User-di-MySQL.jpg","width":1000,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-user-di-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Menampilkan Semua User di MySQL"}]},{"@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\/1772","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=1772"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1772\/revisions"}],"predecessor-version":[{"id":3094,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1772\/revisions\/3094"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1773"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}