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?