php core/scripts/password-hash.sh 'newpasswd'
UPDATE users_field_data SET pass='hash_result_from_previous_command_goes_here' WHERE uid = 1;
DELETE FROM cache_entity WHERE cid = 'values:user:1';
View the discussion thread.