• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

Change Password Query

Tok124

Respected Member
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= "[COLOR="#00FF00"]test123[/COLOR]",
@password = "[COLOR="#00FF00"]blablabla[/COLOR]";

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