{"id":5017,"date":"2021-08-16T06:45:26","date_gmt":"2021-08-15T23:45:26","guid":{"rendered":"http:\/\/materi.smkn43jkt.sch.id\/?p=5017"},"modified":"2021-12-22T21:54:09","modified_gmt":"2021-12-22T14:54:09","slug":"cara-mengatasi-eror-plugin-unix_socket-is-not-loaded-mariadb","status":"publish","type":"post","link":"http:\/\/materi.smkn43jkt.sch.id\/?p=5017","title":{"rendered":"Cara Mengatasi Eror Plugin \u2018unix_socket\u2019 is not loaded MariaDB"},"content":{"rendered":"<p>Cara Mengatasi Eror Plugin \u2018unix_socket\u2019 is not loaded MariaDB, Jika sebelumya Anda menggunakan MariaDB versi 10.1 lalu meng-<em>upgrade<\/em>\u00a0ke versi 10.2, Anda akan mendapatkan eror \u201c<em>Plugin \u2018unix_socket\u2019 is not loaded<\/em>\u201d ketika mencoba masuk ke MariaDB.<\/p>\n<p>Kenapa itu terjadi? Berdasarkan penjelasan dari\u00a0<a href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-14367\" target=\"_blank\" rel=\"noopener noreferrer\">MDEV-14367<\/a>, hal ini terjadi karena plugin otentikasi\u00a0<strong>unix_socket<\/strong>\u00a0yang aktif secara\u00a0<em>default\u00a0<\/em>pada versi 10.1 (dikemas Tim Debian), menjadi tidak aktif saat melakukan\u00a0<em>upgrade<\/em>\u00a0ke versi 10.2 yang dikemas langsung Tim MariaDB.<\/p>\n<p>Lalu bagaimana cara memperbaikinya? Untuk memperbaikinya kita harus mengaktifkan pluginnya dengan cara berikut.<\/p>\n<div class=\"responsive-tabs-wrapper\">\n<div class=\"responsive-tabs responsive-tabs--enabled\">\n<div id=\"tablist1-panel1\" class=\"tabcontent responsive-tabs__panel responsive-tabs__panel--active\" role=\"tabpanel\" aria-hidden=\"false\" aria-labelledby=\"tablist1-tab1\">\n<p>Pertama buka berkas konfigurasi MariaDB.<\/p>\n<pre>$ sudo vim \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/pre>\n<p>Tambahkan konfigurasi berikut, tepat di bawah\u00a0<strong>[mysqld]<\/strong>.<\/p>\n<pre>plugin-load-add = auth_socket.so<\/pre>\n<p>Selanjutnya\u00a0<em>restart service\u00a0<\/em>MariaDB.<\/p>\n<pre>$ sudo systemctl restart mariadb<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<p>Sekarang silakan coba kembali masuk ke MariaDB.<\/p>\n<pre>$ mysql -u root -p<\/pre>\n<h3>Beralih ke otentikasi standar<\/h3>\n<p>Jika Anda lebih prefer untuk menggunakan otentikasi standar, tanpa menggunakan\u00a0<strong>unix_socket<\/strong>, Anda bisa menjalankan perintah berikut pada\u00a0<em>prompt\u00a0<\/em>MariaDB untuk menonaktifkan\u00a0<strong>unix_socket<\/strong>.<\/p>\n<pre>use mysql;\r\nupdate user set plugin='' where User='root';\r\nflush privileges;\r\nexit<\/pre>\n<p>Setelah keluar, Silakan coba masuk kembali, Anda sudah bisa masuk dengan menggunakan otentikasi password.<\/p>\n<p>Semoga bermafaat<\/p>\n<p>&nbsp;<\/p>\n<p>sumber : https:\/\/nothinux.id\/cara-mengatasi-eror-plugin-unix_socket-is-not-loaded-mariadb\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara Mengatasi Eror Plugin \u2018unix_socket\u2019 is not loaded MariaDB, Jika sebelumya Anda menggunakan MariaDB versi 10.1 lalu meng-upgrade\u00a0ke versi 10.2, Anda akan mendapatkan eror \u201cPlugin \u2018unix_socket\u2019 is not loaded\u201d ketika mencoba masuk ke MariaDB. Kenapa itu terjadi? Berdasarkan penjelasan dari\u00a0MDEV-14367, hal ini terjadi karena plugin otentikasi\u00a0unix_socket\u00a0yang aktif secara\u00a0default\u00a0pada versi 10.1 (dikemas Tim Debian), menjadi tidak [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,7],"tags":[],"_links":{"self":[{"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=\/wp\/v2\/posts\/5017"}],"collection":[{"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5017"}],"version-history":[{"count":3,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=\/wp\/v2\/posts\/5017\/revisions"}],"predecessor-version":[{"id":5266,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=\/wp\/v2\/posts\/5017\/revisions\/5266"}],"wp:attachment":[{"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5017"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}