Reset password for q2a from database

0 votes
added Sep 7, 2017 in Database by anonymous
UPDATE qa_users
SET passcheck = UNHEX(SHA1(CONCAT(LEFT(passsalt, 8), 'new_pass', RIGHT(passsalt, 8))))
WHERE userid = 1;

Replace 1 with the user's id and new_pass with the new password for the user. - Malaysia's programming knowledge sharing platform, where everyone can share their finding as reference to others.