{"id":1309,"date":"2019-10-17T00:23:17","date_gmt":"2019-10-16T17:23:17","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1309"},"modified":"2025-04-18T15:21:35","modified_gmt":"2025-04-18T08:21:35","slug":"cara-install-dan-konfigurasi-mysql-pada-centos-8","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/","title":{"rendered":"Cara Install dan Konfigurasi MySQL pada CentOS 8"},"content":{"rendered":"<p>MySQL adalah sistem manajemen basis data relasional open-source yang paling populer.<\/p>\n<p>Versi terbaru dari MySQL database server (saat penulisan) adalah versi 8.0 tersedia untuk instalasi dari repositori\u00a0default CentOS 8.<\/p>\n<p>MySQL 8.0 memperkenalkan banyak fitur dan perubahan baru yang membuat beberapa aplikasi tidak kompatibel dengan versi ini. Sebelum memilih versi MySQL untuk diinstal, lihat dokumentasi aplikasi yang akan Anda gunakan di server CentOS Anda.<\/p>\n<p>CentOS 8 juga menyediakan MariaDB 10.3, yang merupakan \u201c<em>drop-in replacement<\/em>\u201d untuk MySQL 5.7, dengan beberapa batasan. Jika aplikasi Anda tidak kompatibel dengan MySQL 8.0, ada baiknya <a href=\"https:\/\/www.linuxid.net\/post\/install-dan-konfigurasi-mariadb-di-centos-8\/\">instal MariaDB 10.3<\/a>.<\/p>\n<p>Dalam tutorial ini, kami akan menunjukkan kepada Anda cara menginstal dan mengamankan MySQL 8.0 pada sistem CentOS 8.<\/p>\n<h2>Instal MySQL 8.0 pada CentOS 8<\/h2>\n<p>Instal server MySQL 8.0 dengan menggunakan manajer paket CentOS sebagai <a href=\"https:\/\/www.linuxid.net\/post\/cara-mengubah-user-biasa-menjadi-user-sudo-di-centos\/\">root<\/a> atau pengguna dengan hak akses <a href=\"https:\/\/www.linuxid.net\/post\/cara-membuat-user-sudo-di-centos\/\"><code>sudo<\/code><\/a>:<\/p>\n<pre>sudo dnf install @mysql<\/pre>\n<p>Perintah dari\u00a0<code>@mysql<\/code> akan menginstal MySQL\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 mysqld&#13;\n<\/pre>\n<p>Untuk memverifikasi bahwa\u00a0MySQL server sedang berjalan, ketik:<\/p>\n<pre>sudo systemctl status mysqld&#13;\n<\/pre>\n<pre>\u25cf mysqld.service - MySQL 8.0 database server&#13;\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/mysqld.service; enabled; vendor preset: disabled)&#13;\n   Active: active (running) since Thu 2019-10-17 22:09:39 UTC; 15s ago&#13;\n   ...<\/pre>\n<p>Jalankan skrip <code>mysql_secure_installation<\/code> yang melakukan beberapa operasi terkait keamanan dan setel kata sandi root MySQL:<\/p>\n<pre>sudo mysql_secure_installation<\/pre>\n<p>Anda akan diminta untuk mengkonfigurasi <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/validate-password.html\" target=\"_blank\" rel=\"noopener\"><code>VALIDATE PASSWORD PLUGIN<\/code><\/a>, yang digunakan untuk menguji kekuatan kata sandi user MySQL dan meningkatkan keamanan. Ada tiga tingkat kebijakan validasi kata sandi, low, medium, dan strong. Tekan <code>ENTER<\/code> jika Anda tidak ingin mengatur plugin kata sandi yang valid.<\/p>\n<p>Pada prompt berikutnya, Anda akan diminta untuk mengatur kata sandi untuk pengguna root MySQL. Setelah Anda melakukannya, skrip juga akan meminta Anda untuk menghapus pengguna anonim, membatasi akses pengguna root ke mesin lokal, dan menghapus database pengujian. Anda di sarankan untuk menjawab \u201c<code>Y<\/code>\u201d (<strong>yes<\/strong>) untuk semua pertanyaan untuk keamanan yang lebih baik.<\/p>\n<p>Untuk berinteraksi dengan server MySQL dari baris perintah, gunakan utilitas klien MySQL, yang diinstal sebagai dependensi. Uji akses root dengan mengetik:<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>Masukkan kata sandi root saat diminta, dan Anda akan disajikan dengan shell MySQL seperti yang ditunjukkan di bawah ini:<\/p>\n<pre>Welcome to the MySQL monitor.  Commands end with ; or \\g.&#13;\nYour MySQL connection id is 12&#13;\nServer version: 8.0.17 Source distribution<\/pre>\n<p>Pada point ini, Anda telah menginstal dan mengamankan MySQL 8.0 di server CentOS, dan Anda siap menggunakannya.<\/p>\n<h2>Metode Otentikasi MySQL<\/h2>\n<p>MySQL Server versi 8.0 yang ada di dalam repositori CentOS 8 diatur untuk menggunakan plugin autentikasi lama , <code>mysql_native_password<\/code>\u00a0karena beberapa alat klien dan library di CentOS 8 tidak kompatibel dengan metode <code>caching_sha2_password<\/code>, yang ditetapkan sebagai default dalam rilis MySQL 8.0 upstream.<\/p>\n<p>Metode <code>mysql_native_password<\/code> harusnya sudah cukup untuk sebagian besar pengaturan. Namun, jika Anda ingin mengubah plugin autentikasi default menjadi <code>caching_sha2_password<\/code> yang lebih cepat dan memberikan keamanan yang lebih baik, buka file konfigurasi berikut:<span id=\"ezoic-pub-ad-placeholder-161\" class=\"ezoic-adpicker-ad\"\/><\/p>\n<pre>sudo vim \/etc\/my.cnf.d\/mysql-default-authentication-plugin.cnf&#13;\n<\/pre>\n<p>ganti value dari\u00a0\u00a0<code>default_authentication_plugin<\/code>\u00a0menjadi\u00a0<code>caching_sha2_password<\/code>:<\/p>\n<pre>[mysqld]&#13;\ndefault_authentication_plugin=caching_sha2_password<\/pre>\n<p><a href=\"https:\/\/www.linuxid.net\/post\/cara-simpan-file-dan-keluar-dari-text-editor-vim-vi\/\">Tutup dan simpan file,<\/a> dan restart server MySQL agar perubahan diterapkan:<\/p>\n<pre>sudo systemctl restart mysqld<\/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\u00a0<a href=\"https:\/\/www.linuxid.net\/post\/cara-membuat-user-mysql-dan-hak-akses-mysql\/\">user lain dengan hak akses terbatas<\/a>\u00a0untuk alasan keamanan.<\/p>\n<p>Untuk mempelajari lebih lanjut MariaDB, silahkan melihat panduan lain berikut :<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL adalah sistem manajemen basis data relasional open-source yang paling populer. Versi terbaru dari MySQL&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1310,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[15,111,151,41,14],"class_list":["post-1309","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","tag-centos","tag-centos-8","tag-database","tag-mysql","tag-web-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Install dan Konfigurasi MySQL pada 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\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Install dan Konfigurasi MySQL pada CentOS 8 - Linuxid\" \/>\n<meta property=\"og:description\" content=\"MySQL adalah sistem manajemen basis data relasional open-source yang paling populer. Versi terbaru dari MySQL&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-16T17:23:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T08:21:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-dan-Konfigurasi-MySQL-pada-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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/\",\"url\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/\",\"name\":\"Cara Install dan Konfigurasi MySQL pada CentOS 8 - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-dan-Konfigurasi-MySQL-pada-CentOS-8.jpg\",\"datePublished\":\"2019-10-16T17:23:17+00:00\",\"dateModified\":\"2025-04-18T08:21:35+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-dan-Konfigurasi-MySQL-pada-CentOS-8.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-dan-Konfigurasi-MySQL-pada-CentOS-8.jpg\",\"width\":1000,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Install dan Konfigurasi MySQL pada 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":"Cara Install dan Konfigurasi MySQL pada 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\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Install dan Konfigurasi MySQL pada CentOS 8 - Linuxid","og_description":"MySQL adalah sistem manajemen basis data relasional open-source yang paling populer. Versi terbaru dari MySQL&hellip;","og_url":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/","og_site_name":"Linuxid","article_published_time":"2019-10-16T17:23:17+00:00","article_modified_time":"2025-04-18T08:21:35+00:00","og_image":[{"width":1000,"height":530,"url":"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-dan-Konfigurasi-MySQL-pada-CentOS-8.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\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/","url":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/","name":"Cara Install dan Konfigurasi MySQL pada CentOS 8 - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-dan-Konfigurasi-MySQL-pada-CentOS-8.jpg","datePublished":"2019-10-16T17:23:17+00:00","dateModified":"2025-04-18T08:21:35+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-dan-Konfigurasi-MySQL-pada-CentOS-8.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Install-dan-Konfigurasi-MySQL-pada-CentOS-8.jpg","width":1000,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-mysql-pada-centos-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Install dan Konfigurasi MySQL pada 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\/1309","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=1309"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1309\/revisions"}],"predecessor-version":[{"id":2803,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1309\/revisions\/2803"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1310"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}