XF 2.1 How do I reset admin password from backend?

[gogo]

I've changed the domain name of my testing server.

However, I forgot my admin password. The 'forgot password' thing doesn't work due to invalid CAPTCHA after the change of domain name...



How do I change the admin password from the DB? How do I hash the password first.. ?

 

[Mouth]

How do I change the admin password from the DB? How do I hash the password first.. ?

Try this, it's a little old, but may still work?

Unmaintained - Password Reset Query

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...

xenforo.com

 

[Chris D]

These are the steps for XF 2.x:

Unmaintained - Password Reset Query

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...

xenforo.com