Are you first timer at Why not join us and start exchange your programming knowledge with everyone. Register today!

Reset password for q2a from database

0 votes
added Sep 7, 2017 in Database by AliArman Private (420 points)
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.

Please log in or register to response this reference. - Malaysia's programming knowledge sharing platform, where everyone can share their finding as reference to others.