Change Password Query

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

Code:

---

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

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

---

Credits: Tok124