Password Reset Query

[Jake Bunce]

Jake Bunce submitted a new resource:

Password Reset Query - A database query to reset a user's password. Useful for recovery of admin login.

You can use this query to reset a user's password. It is especially useful if you forget your admin password.

You need to replace new-password and 1 (the user_id). You don't have to change salt, but if you do then both instances need to be the same.

Rich (BB code):

UPDATE xf_user_authenticate
SET data = BINARY...

Click to expand...

Read more

Continue reading...

 

D

Temu Spam

W

SQL Query to change post date of every post/topic?