{"id":1803,"date":"2025-04-18T16:08:13","date_gmt":"2025-04-18T09:08:13","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1803"},"modified":"2025-04-18T16:08:13","modified_gmt":"2025-04-18T09:08:13","slug":"cara-membuat-database-mysql-di-linux-terminal","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/","title":{"rendered":"Cara Membuat Database Mysql di Linux Terminal"},"content":{"rendered":"<p>MySQL adalah sistem manajemen basis data relasional open-source yang paling populer. Tutorial ini menjelaskan cara membuat database MySQL atau MariaDB melalui baris perintah.<\/p>\n<h2>Sebelum memulai<\/h2>\n<p>Kami berasumsi bahwa Anda sudah menginstal server MySQL atau MariaDB di sistem Anda.\u00a0Jika belum menginstal MySQL atau MariaDB di server, Anda dapat menginstalnya dengan cepat dengan mengikuti tutorial di bawah ini:<\/p>\n<p>Semua perintah dijalankan sebagai pengguna administratif (hak istimewa minimum yang diperlukan untuk membuat database baru adalah <code>CREATE<\/code>) atau dengan akun root.<\/p>\n<p>Untuk mengakses shell MySQL ketik perintah berikut dan masukkan kata sandi pengguna root MySQL Anda ketika diminta:<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>Jika Anda belum menetapkan kata sandi untuk pengguna root MySQL, Anda dapat menghilangkan switch\u00a0<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>Membuat\u00a0Database MySQL<\/h2>\n<p>Membuat Database MySQL baru sangat mudah, cukup menjalankan satu perintah.<\/p>\n<p>Untuk membuat database MySQL atau MariaDB baru mengeluarkan perintah berikut, di mana\u00a0<code>nama_database<\/code>\u00a0adalah nama database yang ingin Anda buat:<\/p>\n<pre>CREATE DATABASE <code>nama_database<\/code>;<\/pre>\n<pre>Query OK, 1 row affected (0.00 sec)<\/pre>\n<p>Jika Anda mencoba membuat database yang sudah ada, Anda akan melihat pesan kesalahan berikut:<\/p>\n<pre>ERROR 1007 (HY000): Can't create database '<code>nama_database<\/code>'; database exists<\/pre>\n<p>Untuk menghindari kesalahan jika database dengan nama yang sama sudah ada, Anda dapat menggunakan perintah berikut:<\/p>\n<pre>CREATE DATABASE <strong>IF NOT EXISTS<\/strong> <code>nama_database<\/code>;<\/pre>\n<pre>Query OK, 1 row affected, 1 warning (0.00 sec)<\/pre>\n<p>Dalam output di atas, Anda dapat melihat <code>Query OK<\/code> yang berarti kueri berhasil, dan 1 peringatan yang memberi tahu Andabahwa database sudah ada dan tidak ada database baru yang dibuat.<\/p>\n<p>Di Linux, database MySQL dan nama tabel peka huruf besar-kecil (<em>case sensitive<\/em>).<\/p>\n<h2>Melihat Semua Database di MySQL<\/h2>\n<p>Untuk melihat basis data yang Anda buat, 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 harus 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>Pilih Database MySQL<\/h2>\n<p>Saat Anda membuat database, database baru tidak dipilih untuk digunakan. Untuk memilih database sebelum Anda memulai sesi MySQL, gunakan perintah berikut:<\/p>\n<pre>USE <code>nama_database<\/code>;<\/pre>\n<pre>Database changed<\/pre>\n<p>Setelah Anda memilih database, semua operasi selanjutnya seperti membuat tabel akan dilakukan pada database yang dipilih.<\/p>\n<h2>Buat Database MySQL dengan mysqladmin<\/h2>\n<p>Anda juga dapat membuat database MySQL baru 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 membuat database bernama <code>nama_database<\/code>, ketikkan perintah berikut dan masukkan kata sandi root MySQL saat diminta:<\/p>\n<pre>mysqladmin -u root -p create <code>nama_database<\/code><\/pre>\n<h2>Kesimpulan<\/h2>\n<p>Anda telah belajar cara membuat database MySQL melalui terminal Linux. Ini adalah perintah dasar untuk manajemen database MySQL melalui baris perintah.<\/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. Tutorial ini menjelaskan cara&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1804,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[151,41],"class_list":["post-1803","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-database","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Membuat 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-membuat-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 Membuat Database Mysql di Linux Terminal - Linuxid\" \/>\n<meta property=\"og:description\" content=\"MySQL adalah sistem manajemen basis data relasional open-source yang paling populer. Tutorial ini menjelaskan cara&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/cara-membuat-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\/Membuat-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-membuat-database-mysql-di-linux-terminal\/\",\"url\":\"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/\",\"name\":\"Cara Membuat Database Mysql di Linux Terminal - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Membuat-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-membuat-database-mysql-di-linux-terminal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Membuat-Database-Mysql-di-Linux-Terminal.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Membuat-Database-Mysql-di-Linux-Terminal.jpg\",\"width\":952,\"height\":370},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Membuat 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 Membuat 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-membuat-database-mysql-di-linux-terminal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Database Mysql di Linux Terminal - Linuxid","og_description":"MySQL adalah sistem manajemen basis data relasional open-source yang paling populer. Tutorial ini menjelaskan cara&hellip;","og_url":"https:\/\/linuxid.net\/post\/cara-membuat-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\/Membuat-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-membuat-database-mysql-di-linux-terminal\/","url":"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/","name":"Cara Membuat Database Mysql di Linux Terminal - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Membuat-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-membuat-database-mysql-di-linux-terminal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Membuat-Database-Mysql-di-Linux-Terminal.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Membuat-Database-Mysql-di-Linux-Terminal.jpg","width":952,"height":370},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/cara-membuat-database-mysql-di-linux-terminal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Membuat 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\/1803","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=1803"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1803\/revisions"}],"predecessor-version":[{"id":3100,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1803\/revisions\/3100"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1804"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}