{"id":5006,"date":"2021-08-16T06:21:28","date_gmt":"2021-08-15T23:21:28","guid":{"rendered":"http:\/\/materi.smkn43jkt.sch.id\/?p=5006"},"modified":"2021-08-16T06:29:36","modified_gmt":"2021-08-15T23:29:36","slug":"cara-reset-password-root-mariadb","status":"publish","type":"post","link":"http:\/\/materi.smkn43jkt.sch.id\/?p=5006","title":{"rendered":"Cara Reset Password Root MariaDB"},"content":{"rendered":"<p>Cara Reset Password Root MariaDB, ketika anda lupa password root mysql\/mariadb anda tidak akan bisa masuk ke shell prompt mariadb ataupun masuk melalui phpmyadmin, untuk mengatasi hal ini anda bisa melaukan reset pada user root, dan berikut adalah langkah langkah untuk me-reset root MariaDB\/Mysql<\/p>\n<p>Matikan service MariaDB\/Mysql<\/p>\n<p><code><strong>user $<\/strong> systemctl stop mysql<\/code><\/p>\n<p>atau bisa dengan<\/p>\n<p><code><strong>user $<\/strong> service mysql stop<\/code><\/p>\n<p>Jalankan layanan MariaDB\/Mysql tanpa password<\/p>\n<p><code><strong>user $<\/strong>\u00a0mysqld_safe --skip-grant-tables &amp;<\/code><\/p>\n<p>Lalu masuk ke shell prompt mysql<\/p>\n<p><code><strong>user $<\/strong>\u00a0mysql -u root<\/code><\/p>\n<p>setelah itu kita set password baru untuk root MariaDB\/Mysql<\/p>\n<pre>mysql&gt; use mysql;\r\nmysql&gt; update user set password=PASSWORD(\"passwordbaruanda\") where User='root';\r\nmysql&gt; flush privileges;\r\nmysql&gt; quit<\/pre>\n<p>Hentikan kembali service MariaDB\/Mysql<\/p>\n<p><code><strong>user $<\/strong> systemctl stop mysql<\/code><\/p>\n<p>Password telah berhasil di reset sekarang anda bisa masuk seperti biasanya<br \/>\nJalankan service Mariadb\/Mysql<\/p>\n<p><code><strong>user $<\/strong>\u00a0sudo systemctl start mysql<\/code><\/p>\n<p><code><strong>user $<\/strong>\u00a0mysql -u root -p<\/code><\/p>\n<p>sumber : https:\/\/nothinux.id\/cara-mereset-password-root-mariadb\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara Reset Password Root MariaDB, ketika anda lupa password root mysql\/mariadb anda tidak akan bisa masuk ke shell prompt mariadb ataupun masuk melalui phpmyadmin, untuk mengatasi hal ini anda bisa melaukan reset pada user root, dan berikut adalah langkah langkah untuk me-reset root MariaDB\/Mysql Matikan service MariaDB\/Mysql user $ systemctl stop mysql atau bisa dengan [&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,34,35,7],"tags":[],"_links":{"self":[{"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=\/wp\/v2\/posts\/5006"}],"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=5006"}],"version-history":[{"count":3,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=\/wp\/v2\/posts\/5006\/revisions"}],"predecessor-version":[{"id":5009,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=\/wp\/v2\/posts\/5006\/revisions\/5009"}],"wp:attachment":[{"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5006"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/materi.smkn43jkt.sch.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}