linux-pages.com
... arcane linux knowledge collected over the eons, bit by bit ...
From the monthly archives: May 2015
Recovering lost user (admin) password
[ src: https://www.drupal.org/node/44164 ]
Drupal 6
UPDATE users SET pass = MD5(‘givememypasswordback’) WHERE uid=1;
Drupal 7
php ./scripts/password-hash.sh newpwd
The script will output a password hash that is valid for the site, something like:
$S$CTo9G7Lx28rzCfpn4WB2hUlknDKv6QTqHaf82WLbhPT2K5TzKzML
Use it in a SQL query to set new passwd:
