{"id":1522,"date":"2019-07-19T15:49:34","date_gmt":"2019-07-19T08:49:34","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1522"},"modified":"2025-04-18T15:21:57","modified_gmt":"2025-04-18T08:21:57","slug":"cara-menampilkan-semua-database-di-mysql","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/","title":{"rendered":"Cara Menampilkan Semua Database di MySQL"},"content":{"rendered":"

Saat mengelola server database MySQL, salah satu tugas paling umum yang harus Anda lakukan adalah membiasakan diri dengan environment dari MySQL. Tugas-tugas seperti membuat\/melihat daftar database yang berada di server, menampilkan tabel<\/a>-tabel dari database tertentu atau mendapatkan informasi tentang akun user dan hak aksesnya.<\/p>\n

Tutorial ini menjelaskan cara menampilkan semua database di server MySQL atau MariaDB melalui baris perintah.<\/p>\n

Cara Menampilkan Semua Database MySQL<\/h2>\n

Cara paling umum untuk mendapatkan daftar basis data MySQL<\/code> adalah dengan menggunakan klien mysql untuk terhubung ke server MySQL dan menjalankan perintah SHOW DATABASES.<\/code><\/p>\n

Akses server MySQL menggunakan perintah berikut, dan masukkan kata sandi user MySQL Anda saat diminta:<\/p>\n

mysql -u nama_user -p<\/pre>\n
Jika Anda belum menetapkan kata sandi untuk user MySQL, Anda dapat menghilangkan\u00a0switch\u00a0-p<\/code>.<\/p>\n
Dari dalam shell MySQL jalankan perintah berikut:<\/p>\n
SHOW DATABASES;<\/pre>\n
Perintah ini akan mencetak daftar semua database di mana user memiliki semacam hak akses user.<\/a> Outputnya akan mirip dengan ini:<\/p>\n
+--------------------+
\n| Database|
\n+--------------------+
\n| information_schema |
\n| opencart|
\n| wordpress          |
\n+--------------------+
\n3 rows in set (0.00 sec)<\/pre>\n
Perintah lain yang dapat Anda gunakan untuk melihat daftar database adalah SHOW SCHEMAS<\/code> yang merupakan sinonim untuk perintah SHOW DATABASES<\/code>:<\/p>\n
SHOW SCHEMAS;<\/pre>\n
Outputnya akan sama seperti ketika menggunakan perintah SHOW DATABASES<\/code>:<\/p>\n
+--------------------+
\n| Database|
\n+--------------------+
\n| information_schema |
\n| opencart|
\n| wordpress          |
\n+--------------------+
\n3 rows in set (0.00 sec)<\/pre>\n
Tampilkan Semua Database MySQL<\/h2>\n
Untuk menampilkan semua database di server MySQL, Anda harus masuk sebagai user yang dapat mengakses semua database, secara default ini adalah user root MySQL atau menetapkan hak istimewa\u00a0global untuk melakukan perintah\u00a0SHOW DATABASES<\/code>.<\/p>\n
Masuk pengguna root MySQL:<\/p>\n
mysql -u user -p<\/pre>\n
Jalankan perintah SHOW DATABASES<\/code>:<\/p>\n
SHOW DATABASES;<\/pre>\n
Anda akan melihat daftar semua database di server MySQL :<\/p>\n
+--------------------+
\n|     Databases      |
\n+--------------------+
\n| information_schema |
\n| database_name      |
\n| mysql   |
\n| opencart|
\n| wordpress          |
\n| performance_schema |
\n| sys     |
\n+--------------------+
\n
\n7 rows in set (0.00 sec)<\/pre>\n
Memfilter Output Hasil Perintah<\/h2>\n
peritah LIKE<\/code>\u00a0di MySQL dapat digunakan untuk memfilter output dari perintah SHOW DATABASES<\/code> sesuai dengan pola tertentu.<\/p>\n
SHOW DATABASES LIKE pattern;<\/pre>\n
Misalnya, pernyataan berikut akan menampilkan semua database yang namanya dimulai dengan \u2018open<\/code>\u2018:<\/p>\n
SHOW DATABASES LIKE 'open%';<\/pre>\n
+--------------------+
\n| Database|
\n+--------------------+
\n| opencart|
\n+--------------------+
\n1 rows in set (0.00 sec)<\/pre>\n
Tanda persen (%<\/code>) berarti nol, satu, atau beberapa karakter.
Jika Anda ingin melakukan pencarian yang lebih kompleks, pilih table\u00a0schemata<\/code>\u00a0dari database information_schema<\/code> yang berisi informasi tentang semua database.<\/p>\n
Pernyataan berikut akan memberi Anda daftar semua database yang dimulai dengan \u201copen\u201d atau \u201cword\u201d:<\/p>\n
SELECT schema_name FROM information_schema.schemata WHERE schema_name LIKE 'open%' OR schema_name LIKE 'word%';<\/pre>\n
+--------------------+
\n| Database|
\n+--------------------+
\n| opencart|
\n| wordpress          |
\n+--------------------+
\n2 rows in set (0.00 sec)<\/pre>\n
Tampilkan Database MySQL dari Baris Perintah<\/h2>\n
Untuk mendapatkan daftar database tanpa masuk ke shell MySQL, Anda dapat menggunakan perintah mysql<\/code> dengan opsi -e<\/code> yang merupakan singkatan dari execute<\/em> atau mysqlshow<\/code> yang menampilkan informasi database dan tabel.<\/p>\n
Ini sangat berguna ketika Anda ingin bekerja dengan database MySQL menggunakan skrip shell.<\/p>\n
Jalankan perintah berikut di terminal Anda untuk menampilkan daftar semua database :<\/p>\n
mysql -u user -p -e 'show databases;'<\/code><\/pre>\n
+--------------------+
\n| Database|
\n+--------------------+
\n| information_schema |
\n| wordpress          |
\n| opencart|
\n+--------------------+<\/pre>\n
Berikut ini adalah contoh menggunakan perintah mysqlshow<\/code>\u00a0:<\/p>\n
mysqlshow -u user -p<\/code><\/pre>\n
Output akan identik dengan yang dari perintah sebelumnya. Jika Anda ingin memfilter output sesuai dengan kebutuhan, Anda dapat menggunakan perintah grep<\/a>.<\/p>\n
Kesimpulan<\/h2>\n
Anda telah belajar cara mendapatkan daftar semua database di server MySQL Anda.<\/p>\n","protected":false},"excerpt":{"rendered":"
Saat mengelola server database MySQL, salah satu tugas paling umum yang harus Anda lakukan adalah…<\/p>\n","protected":false},"author":2,"featured_media":1523,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[99,41,166],"class_list":["post-1522","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mariadb","tag-mysql","tag-sql"],"yoast_head":"\nCara Menampilkan Semua Database 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-database-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 Database di MySQL - Linuxid\" \/>\n<meta property=\"og:description\" content=\"Saat mengelola server database MySQL, salah satu tugas paling umum yang harus Anda lakukan adalah…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-19T08:49:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T08:21:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-Database-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=\"3 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-database-di-mysql\/\",\"url\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/\",\"name\":\"Cara Menampilkan Semua Database di MySQL - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-Database-di-MySQL.jpg\",\"datePublished\":\"2019-07-19T08:49:34+00:00\",\"dateModified\":\"2025-04-18T08:21:57+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-Database-di-MySQL.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-Database-di-MySQL.jpg\",\"width\":1000,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Menampilkan Semua Database 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 Database 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-database-di-mysql\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menampilkan Semua Database di MySQL - Linuxid","og_description":"Saat mengelola server database MySQL, salah satu tugas paling umum yang harus Anda lakukan adalah…","og_url":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/","og_site_name":"Linuxid","article_published_time":"2019-07-19T08:49:34+00:00","article_modified_time":"2025-04-18T08:21:57+00:00","og_image":[{"width":1000,"height":530,"url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-Database-di-MySQL.jpg","type":"image\/jpeg"}],"author":"xsand","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"xsand","Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/","url":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/","name":"Cara Menampilkan Semua Database di MySQL - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-Database-di-MySQL.jpg","datePublished":"2019-07-19T08:49:34+00:00","dateModified":"2025-04-18T08:21:57+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-Database-di-MySQL.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Menampilkan-Semua-Database-di-MySQL.jpg","width":1000,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-database-di-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Menampilkan Semua Database 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\/1522","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=1522"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1522\/revisions"}],"predecessor-version":[{"id":2883,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1522\/revisions\/2883"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1523"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}