{"id":1073,"date":"2020-01-04T18:02:00","date_gmt":"2020-01-04T11:02:00","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1073"},"modified":"2025-04-18T15:21:19","modified_gmt":"2025-04-18T08:21:19","slug":"install-dan-konfigurasi-mariadb-di-centos-8","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/","title":{"rendered":"Install dan Konfigurasi MariaDB di CentOS 8"},"content":{"rendered":"<p>MariaDB adalah sistem manajemen database relasional multi-threaded\u00a0yang open source, pengganti kompatibel untuk MySQL. MariaDB adalah implementasi default MySQL dan dikembangkan oleh banyak penggiat open source di seluruh dunia.<\/p>\n<p>Tutorial ini menjelaskan cara menginstal dan mengamankan MariaDB 10.3 di CentOS 8.<\/p>\n<h2>Instal MariaDB di\u00a0CentOS 8<\/h2>\n<p>Pada saat menulis artikel ini, versi MariaDB terbaru yang tersedia di repository CentOS 8 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-centos\/\">pengguna dengan hak sudo<\/a> untuk menginstal MariaDB pada CentOS 8:<\/p>\n<pre>sudo dnf install @mariadb<\/pre>\n<p>Modul <code>@mariadb<\/code>\u00a0akan menginstal MariaDB\u00a0server dan semua dependensi.<\/p>\n<p>Setelah instalasi selesai, mulai layanan MariaDB dan aktifkan untuk memulai saat boot dengan mengetik:<\/p>\n<pre>sudo systemctl enable --now mariadb<\/pre>\n<p>Untuk memverifikasi bahwa MariaDB server sedang berjalan, ketik:<\/p>\n<pre>sudo systemctl status mariadb<\/pre>\n<p>Output harus menunjukkan bahwa layanan ini aktif dan berjalan:<\/p>\n<pre>\u25cf mariadb.service - MariaDB 10.3 database server&#13;\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: disabled)&#13;\n   Active: active (running) since Sun 2019-12-08 21:05:26 UTC; 15s ago&#13;\n   ...&#13;\n<\/pre>\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>Skrip akan memuat ulang tabel privilege memastikan bahwa perubahan segera berlaku.<\/p>\n<p>Semua langkah dijelaskan secara rinci dan disarankan untuk menjawab \u201c<strong>Y<\/strong>\u201d (<strong>yes<\/strong>) untuk semua pertanyaan.<\/p>\n<h2>Masuk ke Shell MariaDB<\/h2>\n<p>Untuk terhubung ke server MariaDB melalui terminal sebagai jenis akun root:<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>Masukkan kata sandi root saat diminta, dan Anda akan disajikan dengan shell MariaDB, seperti yang ditunjukkan di bawah ini:<\/p>\n<pre>Welcome to the MariaDB monitor.  Commands end with ; or \\g.&#13;\nYour MariaDB connection id is 18&#13;\nServer version: 10.3.11-MariaDB MariaDB Server&#13;\n&#13;\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.&#13;\n&#13;\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.&#13;\n&#13;\nMariaDB [(none)]&gt; &#13;\n<\/pre>\n<h2>Kesimpulan<\/h2>\n<p>Dalam tutorial ini, kami telah menunjukkan kepada Anda cara menginstal dan mengamankan MariaDB di server CentOS 8.<\/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<p>CentOS 8 juga menyediakan MySQL 8.0. Jika Anda ingin menginstal MySQL daripada MariaDB, lihat panduan <a href=\"https:\/\/www.linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\">Cara Install MySQL pada CentOS 8<\/a>. Perhatikan bahwa Anda tidak dapat menginstal MariaDB dan MySQL di server yang sama.<\/p>\n<p>\u00a0<\/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":1074,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[15,111,151,99],"class_list":["post-1073","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","tag-centos","tag-centos-8","tag-database","tag-mariadb"],"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 CentOS 8 - 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-centos-8\/\" \/>\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 CentOS 8 - 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-centos-8\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-04T11:02:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T08:21:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-CentOS-8.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:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/\",\"url\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/\",\"name\":\"Install dan Konfigurasi MariaDB di CentOS 8 - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-CentOS-8.jpg\",\"datePublished\":\"2020-01-04T11:02:00+00:00\",\"dateModified\":\"2025-04-18T08:21:19+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-CentOS-8.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-CentOS-8.jpg\",\"width\":1000,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install dan Konfigurasi MariaDB di CentOS 8\"}]},{\"@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 CentOS 8 - 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-centos-8\/","og_locale":"id_ID","og_type":"article","og_title":"Install dan Konfigurasi MariaDB di CentOS 8 - 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-centos-8\/","og_site_name":"Linuxid","article_published_time":"2020-01-04T11:02:00+00:00","article_modified_time":"2025-04-18T08:21:19+00:00","og_image":[{"width":1000,"height":530,"url":"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-CentOS-8.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\/install-dan-konfigurasi-mariadb-di-centos-8\/","url":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/","name":"Install dan Konfigurasi MariaDB di CentOS 8 - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-CentOS-8.jpg","datePublished":"2020-01-04T11:02:00+00:00","dateModified":"2025-04-18T08:21:19+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-CentOS-8.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-MariaDB-di-CentOS-8.jpg","width":1000,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Install dan Konfigurasi MariaDB di CentOS 8"}]},{"@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\/1073","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=1073"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1073\/revisions"}],"predecessor-version":[{"id":2722,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1073\/revisions\/2722"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1074"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}