{"id":1857,"date":"2025-04-18T16:08:11","date_gmt":"2025-04-18T09:08:11","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1857"},"modified":"2025-04-18T16:08:11","modified_gmt":"2025-04-18T09:08:11","slug":"tutorial-cara-reset-password-root-mysql","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/","title":{"rendered":"Tutorial Cara Reset Password root Mysql"},"content":{"rendered":"

Lupa kata sandi root MySQL Anda? Jangan khawatir, semua orang bisa lupa, dan juga MySQL adalah pengaturan yang bisa jadi jarang kita lihat. Kecuali jika database error atau ingin memanipulasi data di database.<\/p>\n

Tutorial ini bergantung pada versi server MySQL atau MariaDB yang Anda jalankan di sistem, Anda akan menggunakan perintah yang berbeda untuk memulihkan kata sandi root. Jadi jika Anda memiliki MySQL terinstall di sistem, maka hanya gunakan perintah untuk MySQL.<\/p>\n

Dalam tutorial ini kami akan menunjukkan kepada Anda bagaimana cara mereset kata sandi root MySQL jika Anda lupa. Panduan ini juga bekerja dengan distribusi Linux modern seperti Ubuntu 18.04<\/a> dan CentOS 7.<\/p>\n

Prasyarat<\/h2>\n

Sebelum melanjutkan dengan langkah-langkah di bawah ini, pastikan Anda masuk ke MySQL server sebagai pengguna dengan hak istimewa sudo.<\/p>\n

Identifikasi Versi Server<\/h2>\n

Bergantung pada versi server MySQL atau MariaDB yang Anda jalankan di sistem, Anda harus menggunakan perintah yang berbeda untuk memulihkan kata sandi root.<\/p>\n

Anda dapat menemukan versi server Anda dengan mengetik perintah berikut:<\/p>\n

mysql --version<\/pre>\n
Jika Anda menginstal MySQL di sistem Anda, hasilnya akan terlihat seperti ini:<\/p>\n
mysql  Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using  EditLine wrapper<\/pre>\n
Atau output seperti ini untuk MariaDB:<\/p>\n
mysql  Ver 15.1 Distrib 10.1.33-MariaDB, for debian-linux-gnu (x86_64) using readline 5.<\/pre>\n
Pastikan untuk mencatat versi MySQL atau MariaDB mana yang Anda jalankan.<\/p>\n
Cara Reset Password Root MySQL atau MariaDB<\/h2>\n
Ikuti langkah-langkah ini untuk mengatur ulang kata sandi root MySQL \/ MariaDB Anda:<\/p>\n
1. Stop MySQL\/MariaDB service<\/h3>\n
Untuk mengubah kata sandi root, pertama-tama kita harus menghentikan server MySQL. Untuk melakukannya ketik perintah berikut:<\/p>\n
sudo systemctl stop mysql<\/pre>\n
2. Mulai MySQL\/MariaDB server\u00a0Tanpa Memuat\u00a0grant tables<\/h3>\n
Ketika opsi --skip-grant-tables<\/code> diaktifkan, siapa pun dapat terhubung ke server database tanpa kata sandi dan dengan semua hak istimewa.<\/p>\n
Untuk memulai server database tanpa memuat grant tables ketik:<\/p>\n
sudo mysqld_safe --skip-grant-tables &<\/pre>\n
Simbol &<\/code> di akhir perintah di atas akan menyebabkan program berjalan di latar belakang, sehingga kita dapat terus menggunakan shell.<\/p>\n
3. Login ke MySQL shell<\/h3>\n
Sekarang Anda dapat terhubung ke server database sebagai pengguna root, tanpa dimintai kata sandi oleh MySQL server:<\/p>\n
mysql -u root<\/pre>\n
4. Atur Password Root Baru<\/h3>\n
    \n
  • Jalankan perintah berikut jika Anda memiliki MySQL 5.7.6 dan yang lebih baru atau MariaDB 10.1.20 dan yang lebih baru:\n
    ALTER USER 'root'@'localhost' IDENTIFIED BY 'passwordbaruanda<\/code><\/span>'; FLUSH PRIVILEGES;<\/pre>\n
    Jika pernyataan ALTER USER<\/code> tidak berfungsi, coba ubah tabel pengguna secara langsung:<\/p>\n
    UPDATE mysql.user SET authentication_string = PASSWORD('passwordbaruanda<\/code><\/span>') WHERE User=\"root\" AND Host=\"localhost\"; FLUSH PRIVILEGES;<\/pre>\n
    Jalankan perintah berikut jika Anda memiliki MySQL 5.7.5 dan sebelumnya atau MariaDB 10.1.20 dan sebelumnya:<\/p>\n
    SET PASSWORD FOR 'root'@'localhost' = PASSWORD('passwordbaruanda<\/code><\/span>'); FLUSH PRIVILEGES;<\/pre>\n<\/li>\n<\/ul>\n
    Jika semuanya berjalan dengan baik, Anda akan melihat output berikut:<\/p>\n
    Query OK, 0 rows affected (0.00 sec)<\/pre>\n
    5. Stop dan Start Database Server Secara Normal<\/h3>\n
    Sekarang setelah kata sandi root diatur, kita harus menghentikan server database dan memulainya secara normal.<\/p>\n
    Hentikan server database menggunakan perintah berikut:<\/p>\n
    mysqladmin -u root -p shutdown<\/pre>\n
    Anda akan diminta memasukkan kata sandi root baru:<\/p>\n
    Mulai server database secara normal:<\/p>\n
    6. Verifikasi Password<\/h3>\n
    Untuk memverifikasi bahwa kata sandi root baru telah diterapkan dengan benar ketik:<\/p>\n
    mysql -u root -p<\/pre>\n
    Anda akan diminta memasukkan kata sandi root baru. Anda sudah dapat masuk ke server database Anda.<\/p>\n
    Kesimpulan<\/h2>\n
    Dalam tutorial ini, Anda belajar cara mengatur ulang kata sandi root MySQL atau MariaDB. Pastikan kata sandi root baru Anda kuat dan aman, serta simpan di tempat yang aman.<\/p>\n
    Lihat juga panduan lain tentang mengolah dan mengatur database :<\/p>\n","protected":false},"excerpt":{"rendered":"
    Lupa kata sandi root MySQL Anda? Jangan khawatir, semua orang bisa lupa, dan juga MySQL…<\/p>\n","protected":false},"author":2,"featured_media":1858,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[41],"class_list":["post-1857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql"],"yoast_head":"\nTutorial Cara Reset Password root Mysql - 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\/tutorial-cara-reset-password-root-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tutorial Cara Reset Password root Mysql - Linuxid\" \/>\n<meta property=\"og:description\" content=\"Lupa kata sandi root MySQL Anda? Jangan khawatir, semua orang bisa lupa, dan juga MySQL…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-18T09:08:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Tutorial-Cara-Reset-Password-root-Mysql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"952\" \/>\n\t<meta property=\"og:image:height\" content=\"370\" \/>\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\/tutorial-cara-reset-password-root-mysql\/\",\"url\":\"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/\",\"name\":\"Tutorial Cara Reset Password root Mysql - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Tutorial-Cara-Reset-Password-root-Mysql.jpg\",\"datePublished\":\"2025-04-18T09:08:11+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Tutorial-Cara-Reset-Password-root-Mysql.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Tutorial-Cara-Reset-Password-root-Mysql.jpg\",\"width\":952,\"height\":370},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutorial Cara Reset Password root Mysql\"}]},{\"@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":"Tutorial Cara Reset Password root Mysql - 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\/tutorial-cara-reset-password-root-mysql\/","og_locale":"id_ID","og_type":"article","og_title":"Tutorial Cara Reset Password root Mysql - Linuxid","og_description":"Lupa kata sandi root MySQL Anda? Jangan khawatir, semua orang bisa lupa, dan juga MySQL…","og_url":"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/","og_site_name":"Linuxid","article_published_time":"2025-04-18T09:08:11+00:00","og_image":[{"width":952,"height":370,"url":"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Tutorial-Cara-Reset-Password-root-Mysql.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\/tutorial-cara-reset-password-root-mysql\/","url":"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/","name":"Tutorial Cara Reset Password root Mysql - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Tutorial-Cara-Reset-Password-root-Mysql.jpg","datePublished":"2025-04-18T09:08:11+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Tutorial-Cara-Reset-Password-root-Mysql.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Tutorial-Cara-Reset-Password-root-Mysql.jpg","width":952,"height":370},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/tutorial-cara-reset-password-root-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Tutorial Cara Reset Password root Mysql"}]},{"@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\/1857","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=1857"}],"version-history":[{"count":2,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1857\/revisions"}],"predecessor-version":[{"id":3029,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1857\/revisions\/3029"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1858"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}