{"id":8681,"date":"2025-04-30T09:02:55","date_gmt":"2025-04-30T02:02:55","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=8681"},"modified":"2026-02-16T10:30:41","modified_gmt":"2026-02-16T03:30:41","slug":"cara-reset-password-root-mysql-di-whm","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-reset-password-root-mysql-di-whm\/","title":{"rendered":"Cara Reset Password Root MySQL di WHM Pada VPS cPanel"},"content":{"rendered":"\n<p>Pernah mengalami lupa password root MySQL di VPS cPanel Anda? Tenang, Anda tidak sendiri. Banyak pengguna VPS yang menghadapi situasi serupa, dan kabar baiknya, solusinya tidak serumit yang dibayangkan. Melakukan reset password root MySQL di WHM bisa dilakukan dalam beberapa langkah mudah, tanpa perlu menginstal ulang atau kehilangan data penting.<\/p>\n\n\n\n<p>Dalam artikel ini, kami akan membahas tentang apa itu MySQL root beserta cara reset password root MySQL di WHM secara mudah, sehingga Anda dapat mengelola database di server kembali dengan aman dan cepat. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Apa Itu MySQL Root? <\/h2>\n\n\n\n<p>Dalam sistem manajemen database MySQL, user root adalah akun utama yang memiliki hak akses penuh terhadap semua database yang ada di server. Ketika Anda menggunakan VPS cPanel yang dikelola melalui <a href=\"https:\/\/blog.rumahweb.com\/whm-adalah\/\" target=\"_blank\" rel=\"noopener\" title=\"whm adalah\">WHM<\/a> (WebHost Manager), MySQL root berperan sebagai <em>superuser <\/em>yang bisa melakukan semua operasi penting, seperti membuat, menghapus, dan memodifikasi database maupun user MySQL lainnya.<\/p>\n\n\n\n<p>Selain itu, user <em>superuser <\/em>ini dapat digunakan oleh administrator server untuk keperluan manajemen tingkat lanjut, seperti:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Menyambungkan aplikasi langsung ke MySQL server.<\/li>\n\n\n\n<li>Melakukan <em>backup <\/em>atau <em>restore <\/em>database manual.<\/li>\n\n\n\n<li>Menjalankan perintah SQL melalui terminal atau <em>script<\/em>.<\/li>\n\n\n\n<li>Memperbaiki <em>error <\/em>database di luar akses cPanel biasa.<\/li>\n<\/ul>\n\n\n\n<p>Karena fungsinya sangat krusial, mengetahui dan menjaga kerahasiaan password root MySQL sangat penting untuk dilakukan. Tanpa akses ini, Anda akan kesulitan mengelola database melalui <em>command line<\/em>, melakukan <em>troubleshooting<\/em>, atau menjalankan proses otomatisasi di sisi server.<\/p>\n\n\n\n<p>Namun, jika password root MySQL terlupa atau tidak diketahui, maka perlu dilakukan reset password MySQL root agar pengelolaan server tetap berjalan optimal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Reset Password Root MySQL di WHM<\/h2>\n\n\n\n<p>Berikut adalah langkah demi langkah untuk melakukan reset password root MySQL di WHM pada layanan VPS cPanel: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Login ke WHM VPS Anda. <\/li>\n\n\n\n<li>Pada kolom pencarian, ketikkan mysql dan pilih menu <strong>Change Database Root Password<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"615\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password-1024x615.png\" alt=\"menu reset password root mysql whm\" class=\"wp-image-54837\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password-1024x615.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password-300x180.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password-768x461.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password-370x222.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password-270x162.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password-570x342.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password-740x445.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/change-database-root-password.png 1195w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Isi password baru dengan kombinasi yang kuat. Gunakan huruf besar, kecil, spesial karakter dan angka. Pastikan bahwa indikator password kuat dan klik tombol <strong>change password<\/strong> untuk mengubahnya.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/reset-password-root-mysql.png\"><img loading=\"lazy\" decoding=\"async\" width=\"926\" height=\"524\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/reset-password-root-mysql.png\" alt=\"cara reset password root mysql di whm pada vps cpanel\" class=\"wp-image-54838\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/reset-password-root-mysql.png 926w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/reset-password-root-mysql-300x170.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/reset-password-root-mysql-768x435.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/reset-password-root-mysql-370x209.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/reset-password-root-mysql-270x153.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/reset-password-root-mysql-570x323.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2018\/02\/reset-password-root-mysql-740x419.png 740w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/a><\/figure>\n\n\n\n<p>Sampai tahap ini, proses reset password root MySQL di WHM telah selesai. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Apakah bisa melihat password root MySQL di server? <\/h2>\n\n\n\n<p>Pada sistem cPanel\/WHM, saat instalasi awal atau konfigurasi awal VPS, biasanya sistem secara otomatis menyimpan kredensial root MySQL di file <em>\/root\/.my.cnf<\/em>. <\/p>\n\n\n\n<p>Isi file ini biasanya berupa:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;client]\nuser=root\npassword=PasswordRootMysqlAnda<\/code><\/pre>\n\n\n\n<p>Untuk bisa melihat data tersebut, Anda bisa login ke VPS melalui SSH dan gunakan  <em>command <\/em>berikut ini:<\/p>\n\n\n\n<p><pre class=\"\">cat \/root\/.my.cnf<\/pre><\/p>\n\n\n\n<p>Anda akan melihat <em>username <\/em>dan <em>password <\/em>root MySQL yang digunakan oleh sistem untuk koneksi internal. Hal ini memungkinkan proses-proses otomatis (seperti backup, update database, dsb.) tetap berjalan, tanpa harus memasukkan password secara manual.<\/p>\n\n\n\n<p>Demikian artikel kami tentang cara reset password root MySQL di WHM pada VPS cPanel, semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pernah mengalami lupa password root MySQL di VPS cPanel Anda? Tenang, Anda tidak sendiri. Banyak pengguna VPS yang menghadapi situasi serupa, dan kabar baiknya, solusinya tidak serumit yang dibayangkan. Melakukan reset password root MySQL di WHM bisa dilakukan dalam beberapa langkah mudah, tanpa perlu menginstal ulang atau kehilangan data penting. Dalam artikel ini, kami akan [&hellip;]<\/p>\n","protected":false},"author":329,"featured_media":54841,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[177],"tags":[18,134,431],"class_list":{"0":"post-8681","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-vps","8":"tag-cpanel","9":"tag-mysql","10":"tag-whm"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/04\/banner-cara-reset-password-root-mysql.png","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-2g1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/8681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/users\/329"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=8681"}],"version-history":[{"count":1,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/8681\/revisions"}],"predecessor-version":[{"id":61974,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/8681\/revisions\/61974"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/54841"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=8681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=8681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=8681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}