How to change root admin user password in Drupal ?

In order to reset the root or superadmin password on a drupal system, login into the database by looking at the
settings.php
. You can use phpMyAdmin or any other MySQL utilities like SQLYog, or MySQL command line. Run the following query to reset the password. UPDATE users SET pass = MD5('password') WHERE uid = 1 The user id of administrator is always 1. Password field in drupal is stored as MD5 of the actual string password. So running the above query would set your password as password of the superadmin user. 09 Apr, 2010
Comments (2)
  • anybody who might read this now should be warned that Drp7 now uses SHA1 hashes for passwords, not MD5s.

    If you set pass=“$S$C6x2r.aW5Nkg7st6/u.IKWjTerHXscjPtu4spwhCVZlP89UKcbb/”
    Then your password will be “NEW_TEMP_PASSWORD”

    By Jaxxed on 25 Oct, 2012
  • Thank you - works brilliantly

    Thank you, thank you, thank you!

    Oh, and thank you!

    Best
    Pam

    By mcpixelchick on 22 Jul, 2010
You may also like
Tags
On Facebook
Email Newsletter