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.

Comments

  1. UnknownJuly 7, 2012 at 8:25 AM

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

    ReplyDelete
  2. MadchenFebruary 14, 2013 at 10:32 AM

    jajaja

    ReplyDelete
  3. MadchenFebruary 14, 2013 at 11:31 AM

    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
  4. All MineApril 24, 2014 at 11:05 AM

    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
  5. Yura FilimonovAugust 8, 2014 at 4:32 AM

    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

Post a Comment

Popular posts from this blog

Syntax Highlighting with Blogger Engine

I was trying to style the code snippets highlighted as code as developer in my blog. Did it using some custom css but no positive impression. Recently googling, found an article abt that here . This can be done using syntaxhiglighter . Drop this code right before your </head> tag... and save. And here is the way how you can use it. 1. Using <script> tag with CDATA This will output.... // Commenting this function function custom_one($var) { if($one == $two) { $three = array( 'one', 'two' ); } } 2. Using the <pre> tag. // Commenting this function function custom_one($var) { if($one == $two) { $three = array( 'one', 'two' ); } } This will output.... // Commenting this function function custom_one($var) { if($one == $two) { $three = array( 'one', 'two' ); } }
Read more