Changing a user password through phpMyAdmin Hopefully this should be a quickly resolvable query:

If I only have phpMyAdmin as a means of changing a password - e.g. say I can't login and need to change the Admin password (and Drush is equally not available etc) should I be able to reset a user's password using the following query:

UPDATE drupal_users SET pass = SHA2( 'the_password', 256 ) WHERE uid = 20


where the drupal tables are prefixed with "drupal_"

I have tried the above query in order to change the password for a user, but when using the password specified in the above sql statement I am still unable to login.  This makes me think I am missing something here.

Anyone got any ideas how to change a drupal 7 user password via PhpMyAdmin using SQL?
Drupal 7 uses a hash salt (see your settings.php) in addition to several other bit of information in order to create a SHA2 of the users PW. You should really use drush to change a user's pw if you need to.