Change Password Query

[Wise]

Hello. Here is a little query that will change your password. Usually you have a website where you can change it. But if you dont have that then you can use this query. All you need to do is to replace the green text. Good luck



SET
@username= "test123",
@password = "blablabla";

UPDATE account
SET sha_pass_hash = ( SHA1(CONCAT(UPPER(@username), ':', UPPER (@password))) )
WHERE username = @username;



Credits: Tok124