How to manually change the Drupal 6 admin password


If you or your organisation is using Drupal in deploying and developing your website, and at some point, you forgot to remember the Drupal admin password, you can easily reset it by using PhpMyAdmin:
  • Login to your website's cpanel.
  • Open phpmyadmin control panel.
  • Open the your Drupal's MySQL database.
  • Enter the MySQL command:
    UPDATE users SET pass = md5('newpassword') WHERE uid = 1;
    view raw gistfile1.sql hosted with ❤ by GitHub
    Where: newpassword = your desired password
If you have Drupal 7 installed, follow the instructions here.
    Powered by Blogger.