{"id":550,"date":"2020-05-17T00:55:19","date_gmt":"2020-05-16T17:55:19","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=550"},"modified":"2025-04-18T15:21:00","modified_gmt":"2025-04-18T08:21:00","slug":"cara-install-mariadb-di-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/","title":{"rendered":"Cara Install MariaDB di Ubuntu 20.04"},"content":{"rendered":"<p>MariaDB adalah sistem manajemen basis data relasional open source. Awalnya dirancang sebagai pengganti drop-in biner yang kompatibel dari MySQL.<\/p>\n<p>MariaDB dikembangkan dan dikelola oleh pengembang asli MySQL dan oleh komunitas open source.<span id=\"ezoic-pub-ad-placeholder-158\" class=\"ezoic-adpicker-ad\"\/><span id=\"ezoic-pub-ad-placeholder-138\" class=\"ezoic-adpicker-ad\"\/><\/p>\n<p>Panduan ini menjelaskan cara menginstal dan MariaDB di Ubuntu 20.04.<\/p>\n<h2>Persiapan<\/h2>\n<p>Lakukan langkah-langkah berikut sebagai root atau <a href=\"https:\/\/www.linuxid.net\/post\/cara-membuat-user-sudo-di-ubuntu-linux\/\">pengguna dengan hak sudo<\/a> untuk menginstal MariaDB pada Server Ubuntu:<\/p>\n<h2>Install MariaDB di Ubuntu<\/h2>\n<p>Pada saat menulis artikel ini, versi MariaDB terbaru yang tersedia di repository utama Debian adalah versi 10.3. Untuk melakukan installasi, silahkan gunakan perintah berikut<\/p>\n<pre>sudo apt update&#13;\nsudo apt install mariadb-server<\/pre>\n<p>Layanan MariaDB akan mulai secara otomatis setelah proses instalasi selesai. Untuk memverifikasi, periksa status layanan dengan perintah :<br \/><span id=\"ezoic-pub-ad-placeholder-156\" class=\"ezoic-adpicker-ad\"\/><\/p>\n<pre>sudo systemctl status mariadb<\/pre>\n<p>Outputnya akan terlihat kurang lebih seperti berikut :<\/p>\n<pre>\u25cf mariadb.service - MariaDB 10.3.22 database server&#13;\n     Loaded: loaded (\/lib\/systemd\/system\/mariadb.service; enabled; vendor preset: enabled)&#13;\n     Active: active (running) since Wed 2020-05-20 16:52:07 UTC; 12s ago&#13;\n     ...<\/pre>\n<p>Pada poin ini, mariadb sudah terinstall pada sistem ubuntu Anda.<\/p>\n<h2>Berinteraksi dengan MariaDB<\/h2>\n<p>Untuk berinteraksi dengan MariaDB server dari baris perintah, gunakan utilitas <code>mysql<\/code> client atau alias dari <code>mariadb<\/code>. Tool ini diinstal sebagai ketergantungan paket server MariaDB.<\/p>\n<p>Di Ubuntu, user root MariaDB diautentikasi oleh plugin <code>auth_socket<\/code> secara default. Plugin bekerja dengan memeriksa apakah user sistem lokal yang menjalankan program klien cocok dengan nama user MariaDB yang ditentukan. Ini berarti Anda tidak dapat mengautentikasi sebagai root dengan memberikan kata sandi.<\/p>\n<p>Untuk masuk ke server MariaDB sebagai pengguna root, ketik:<\/p>\n<pre>sudo mysql<\/pre>\n<p>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 61&#13;\nServer version: 10.3.22-MariaDB-1ubuntu1 Ubuntu 20.04&#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; Bye&#13;\n<\/pre>\n<p>Jika Anda ingin masuk ke server MariaDB Anda sebagai root menggunakan program eksternal seperti phpMyAdmin dan juga cms atau web client pada umumnya, Anda memiliki dua opsi.<\/p>\n<p>Yang pertama adalah mengubah metode autentikasi dari\u00a0<code>auth_socket<\/code>\u00a0menjadi<code>\u00a0mysql_native_password<\/code>. Anda dapat melakukannya dengan menjalankan perintah berikut:<\/p>\n<pre>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ganti_dengan_password_anda_sendiri';&#13;\nFLUSH PRIVILEGES;<\/pre>\n<p>Opsi kedua yang disarankan adalah membuat pengguna administratif khusus baru dengan akses ke semua basis data:<\/p>\n<pre>GRANT ALL PRIVILEGES ON *.* TO 'nama_user_anda'@'localhost' IDENTIFIED BY 'ganti_dengan_password_anda_sendiri';<\/pre>\n<p>Anda dapat memberi nama pengguna administratif apa pun yang Anda inginkan, tetapi pastikan Anda menggunakan kata sandi yang kuat.<\/p>\n<h2>Kesimpulan<\/h2>\n<p>Kami telah menunjukkan kepada Anda cara menginstal MariaDB di Ubuntu 20.04. Setelah server database Anda aktif dan berjalan, langkah Anda selanjutnya adalah mempelajari cara mengelola <a href=\"https:\/\/www.linuxid.net\/post\/cara-membuat-user-mysql-dan-hak-akses-mysql\/\">akun pengguna<\/a> dan database MariaDB.<\/p>\n<p>Jika Anda memiliki pertanyaan atau umpan balik, jangan ragu untuk meninggalkan komentar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB adalah sistem manajemen basis data relasional open source. Awalnya dirancang sebagai pengganti drop-in biner&hellip;<\/p>\n","protected":false},"author":2,"featured_media":551,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[99,9,82],"class_list":["post-550","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu","tag-mariadb","tag-ubuntu","tag-ubuntu-20-04"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Install MariaDB di Ubuntu 20.04 - 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-install-mariadb-di-ubuntu-20-04\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Install MariaDB di Ubuntu 20.04 - Linuxid\" \/>\n<meta property=\"og:description\" content=\"MariaDB adalah sistem manajemen basis data relasional open source. Awalnya dirancang sebagai pengganti drop-in biner&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-16T17:55:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T08:21:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MariaDB-di-Ubuntu-20.04.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"407\" \/>\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-install-mariadb-di-ubuntu-20-04\/\",\"url\":\"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/\",\"name\":\"Cara Install MariaDB di Ubuntu 20.04 - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MariaDB-di-Ubuntu-20.04.jpg\",\"datePublished\":\"2020-05-16T17:55:19+00:00\",\"dateModified\":\"2025-04-18T08:21:00+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MariaDB-di-Ubuntu-20.04.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MariaDB-di-Ubuntu-20.04.jpg\",\"width\":768,\"height\":407},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Install MariaDB di Ubuntu 20.04\"}]},{\"@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 Install MariaDB di Ubuntu 20.04 - 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-install-mariadb-di-ubuntu-20-04\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Install MariaDB di Ubuntu 20.04 - Linuxid","og_description":"MariaDB adalah sistem manajemen basis data relasional open source. Awalnya dirancang sebagai pengganti drop-in biner&hellip;","og_url":"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/","og_site_name":"Linuxid","article_published_time":"2020-05-16T17:55:19+00:00","article_modified_time":"2025-04-18T08:21:00+00:00","og_image":[{"width":768,"height":407,"url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MariaDB-di-Ubuntu-20.04.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-install-mariadb-di-ubuntu-20-04\/","url":"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/","name":"Cara Install MariaDB di Ubuntu 20.04 - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MariaDB-di-Ubuntu-20.04.jpg","datePublished":"2020-05-16T17:55:19+00:00","dateModified":"2025-04-18T08:21:00+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MariaDB-di-Ubuntu-20.04.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-MariaDB-di-Ubuntu-20.04.jpg","width":768,"height":407},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxid.net\/post\/cara-install-mariadb-di-ubuntu-20-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Install MariaDB di Ubuntu 20.04"}]},{"@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\/550","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=550"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/550\/revisions"}],"predecessor-version":[{"id":2599,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/550\/revisions\/2599"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/551"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}