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: UPDATE users SET pass =’$S$CTo9G7Lx28rzCfpn4WB2hUlknDKv6QTqHaf82WLbhPT2K5TzKzML’ […]