Bagaimana cara memperbaiki error 1045 jika saya lupa password root MySQL?

Responsive Ad Header

Question

Grade: Education Subject: Support
Bagaimana cara memperbaiki error 1045 jika saya lupa password root MySQL?
Asked by:
73 Viewed 73 Answers
Responsive Ad After Question

Answer (73)

Best Answer
(451)
Jika Anda lupa password root MySQL, Anda perlu me-restart server MySQL dalam mode aman (safe mode) tanpa menggunakan password, lalu mengganti password root melalui command line client MySQL. Langkah-langkahnya meliputi menghentikan server, memulainya dengan opsi `--skip-grant-tables`, terhubung tanpa password, menjalankan `FLUSH PRIVILEGES;` dan `ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';`, lalu memulai ulang server secara normal.