{"id":1554,"date":"2019-07-11T12:27:50","date_gmt":"2019-07-11T05:27:50","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1554"},"modified":"2025-04-18T15:21:57","modified_gmt":"2025-04-18T08:21:57","slug":"install-dan-konfigurasi-mariadb-di-debian-10","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/","title":{"rendered":"Install dan Konfigurasi MariaDB di Debian 10"},"content":{"rendered":"<p>MariaDB adalah sistem manajemen database relasional multi-threaded\u00a0yang open source, pengganti kompatibel untuk MySQL. MariaDB adalah implementasi default MySQL di Debian.<\/p>\n<p>Tutorial ini menjelaskan cara menginstal MariaDB di Debian 10.<\/p>\n<h2>Instal MariaDB di Debian 10<\/h2>\n<p>Pada saat menulis artikel ini, versi MariaDB terbaru yang tersedia di repository utama Debian adalah versi 10.3.<\/p>\n<p>Lakukan langkah-langkah berikut sebagai root atau <a href=\"https:\/\/www.linuxid.net\/post\/cara-membuat-user-sudo-di-debian-linux\/\">pengguna dengan hak sudo<\/a> untuk menginstal MariaDB pada Debian 10:<\/p>\n<ol>\n<li>Mulailah dengan memperbarui indeks paket:\n<pre>sudo apt update<\/pre>\n<\/li>\n<li>Instal paket server dan klien MariaDB dengan menjalankan perintah berikut:\n<pre>sudo apt install mariadb-server<\/pre>\n<\/li>\n<li>Layanan MariaDB akan mulai secara otomatis. Untuk memverifikasi, periksa status layanan:\n<pre>sudo systemctl status mariadb<\/pre>\n<p>Outputnya akan terlihat seperti ini:<\/p>\n<pre>\u25cf mariadb.service - MariaDB 10.3.15 database server&#13;\n   Loaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)&#13;\n   Active: active (running) since Thu 2019-07-11 14:36:28 PDT; 19min ago&#13;\n     Docs: man:mysqld(8)&#13;\nhttps:\/\/mariadb.com\/kb\/en\/library\/systemd\/&#13;\n Main PID: 4509 (mysqld)&#13;\n   Status: \"Taking your SQL requests now...\"&#13;\n    Tasks: 30 (limit: 2359)&#13;\n   Memory: 78.6M&#13;\n   CGroup: \/system.slice\/mariadb.service&#13;\n\u2514\u25004509 \/usr\/sbin\/mysqld<\/pre>\n<\/li>\n<\/ol>\n<h2>Amankan MariaDB<\/h2>\n<p>MariaDB dilengkapi dengan skrip yang dapat membantu Anda meningkatkan keamanan instalasi. Untuk memulai skrip ketik <code>mysql_secure_installation<\/code> di terminal Anda:<\/p>\n<pre>sudo mysql_secure_installation<\/pre>\n<p>Anda akan diminta untuk mengatur kata sandi untuk akun root, menghapus pengguna anonim, membatasi akses pengguna root ke mesin lokal dan menghapus database pengujian.<\/p>\n<pre>...&#13;\nEnter current password for root (enter for none):&#13;\n...&#13;\nSet root password? [Y\/n] Y&#13;\nNew password: &#13;\nRe-enter new password: &#13;\n...&#13;\nRemove anonymous users? [Y\/n] Y&#13;\n...&#13;\nDisallow root login remotely? [Y\/n] Y&#13;\n...&#13;\nRemove test database and access to it? [Y\/n] Y&#13;\n...&#13;\nReload privilege tables now? [Y\/n] Y&#13;\n...&#13;\nThanks for using MariaDB!<\/pre>\n<p>Jika dipilih, skrip akan memuat ulang tabel privilege memastikan bahwa perubahan segera berlaku.<\/p>\n<p>Semua langkah dijelaskan secara rinci dan disarankan untuk menjawab \u201cY\u201d (yes) untuk semua pertanyaan.<\/p>\n<h2>Metode Otentikasi<\/h2>\n<p>Secara default, pengguna root MariaDB menggunakan plugin otentikasi <code>unix_socket<\/code> yang memeriksa user id yang aktif saat memanggil client tool <code>mysql<\/code>.<\/p>\n<p>Ini artinya, Anda dapat terhubung ke server MariaDB\u00a0<em>hanya<\/em>\u00a0sebagai user root atau dengan menambahkan sudo ke perintah. User lain yang bukan root, atau tidak memiliki hak akses sudo tidak akan dapat mengakses database mysql (sama sekali).<\/p>\n<p>Untuk meningkatkan keamanan, disarankan untuk tetap menggunakan plugin autentikasi default dan memungkinkan pengguna root untuk mengautentikasi hanya melalui Unix sockets.<\/p>\n<p>Jika Anda ingin mengubah otentikasi root ke metode klasik, yaitu dengan password biasa, masuk ke server MariaDB:<\/p>\n<pre>sudo mysql<\/pre>\n<p>Jalankan pernyataan berikut untuk mengubah plugin otentikasi:<\/p>\n<pre>ALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password;&#13;\nALTER USER 'root'@'localhost' IDENTIFIED BY 'g4nt!_d3ng9an_p4$$w0rd_4nd4';<\/pre>\n<p>Anda sekarang dapat terhubung ke server MariaDB menggunakan kata sandi baru:<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>Mengubah plugin otentikasi juga akan memungkinkan Anda untuk login sebagai <code>root<\/code> dari program eksternal seperti phpMyAdmin<\/p>\n<h2>Kesimpulan<\/h2>\n<p>Dalam tutorial ini, kami telah menunjukkan kepada Anda cara menginstal dan mengamankan MariaDB di server Debian 10.<\/p>\n<p>Menggunakan unix socket sebagai akses root memang memiliki kemudahan, namun alangkah baiknya Anda membuat <a href=\"https:\/\/www.linuxid.net\/post\/cara-membuat-user-mysql-dan-hak-akses-mysql\/\">user lain dengan hak akses terbatas<\/a> untuk alasan keamanan.<\/p>\n<p>Untuk mempelajari lebih lanjut MariaDB, silahkan melihat panduan lain berikut :<\/p>\n<p>Jika Anda lebih suka antarmuka web daripada baris perintah, Anda dapat menginstal <a href=\"https:\/\/www.linuxid.net\/post\/cara-install-dan-konfigurasi-phpmyadmin-apache-di-ubuntu\/\">phpMyAdmin<\/a> dan mengelola database dan pengguna MariaDB dengan mudah menggunakan phpMyAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB adalah sistem manajemen database relasional multi-threaded\u00a0yang open source, pengganti kompatibel untuk MySQL. MariaDB adalah&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1555,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[16,79,99,41],"class_list":["post-1554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-debian","tag-debian","tag-debian-10","tag-mariadb","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Install dan Konfigurasi MariaDB di Debian 10 - 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\/install-dan-konfigurasi-mariadb-di-debian-10\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install dan Konfigurasi MariaDB di Debian 10 - Linuxid\" \/>\n<meta property=\"og:description\" content=\"MariaDB adalah sistem manajemen database relasional multi-threaded\u00a0yang open source, pengganti kompatibel untuk MySQL. MariaDB adalah&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-11T05:27:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T08:21:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-Debian-10.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:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/\",\"url\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/\",\"name\":\"Install dan Konfigurasi MariaDB di Debian 10 - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-Debian-10.jpg\",\"datePublished\":\"2019-07-11T05:27:50+00:00\",\"dateModified\":\"2025-04-18T08:21:57+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-Debian-10.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-Debian-10.jpg\",\"width\":1000,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install dan Konfigurasi MariaDB di Debian 10\"}]},{\"@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":"Install dan Konfigurasi MariaDB di Debian 10 - 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\/install-dan-konfigurasi-mariadb-di-debian-10\/","og_locale":"id_ID","og_type":"article","og_title":"Install dan Konfigurasi MariaDB di Debian 10 - Linuxid","og_description":"MariaDB adalah sistem manajemen database relasional multi-threaded\u00a0yang open source, pengganti kompatibel untuk MySQL. MariaDB adalah&hellip;","og_url":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/","og_site_name":"Linuxid","article_published_time":"2019-07-11T05:27:50+00:00","article_modified_time":"2025-04-18T08:21:57+00:00","og_image":[{"width":1000,"height":530,"url":"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-Debian-10.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:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/","url":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/","name":"Install dan Konfigurasi MariaDB di Debian 10 - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-Debian-10.jpg","datePublished":"2019-07-11T05:27:50+00:00","dateModified":"2025-04-18T08:21:57+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-Debian-10.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-Debian-10.jpg","width":1000,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-debian-10\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Install dan Konfigurasi MariaDB di Debian 10"}]},{"@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\/1554","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=1554"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1554\/revisions"}],"predecessor-version":[{"id":2898,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1554\/revisions\/2898"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1555"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}