Tuesday, June 19, 2012

How to Reset Root Password in Drupal 7 with phpMyAdmin

Copy the hash..
$S$C6x2r.aW5Nkg7st6/u.IKWjTerHXscjPtu4spwhCVZlP89UKcbb/
(that’s the hash for newPassword).
 

Navigate to your phpMyAdmin (likely in your control panel online somewhere).
Then browse the User table for the Root user, look like his.




Take the copied hashed text and paste it into the pass field of the Root user and hit “Go”.

See this If you want to reset Drupal pasword using Drush.

5 comments:

  1. can you please create the hash for the word "john316" ... thanks i am a newbie

    ReplyDelete
  2. I did found the way to make all the hash stuff to work, here is what you asked for Mymy Lozada:

    $S$DKI1budON2NKc6TrKdYPCoXV1DM7dM6s/nX2r4Th9EA4AxSTUV2r

    ReplyDelete
  3. hello. i tried this and when i attempt to log in to the site with the new password its not working. is there something i'm missing? i'm using a localhost for dev purposes.

    ReplyDelete
  4. This won't work, because you have to generate a unique hash for your Drupal installation, as described here:
    https://www.drupal.org/node/1023428

    Note the link on the password-reset file, it's similar to the index file change below.

    Or you can edit your index file, as shown here:
    https://www.drupal.org/node/992400#comment-8858663

    ReplyDelete