How to change the XenForo Admin password with PhpMyAdmin

0
64

Have you ever managed 1 site Xenforo but do not remember the password of Nick Admin for some reason. Do not worry, we have a quick solution is to directly intervene in the Forum database through phpMyAdmin. The solution is a lot of risk, so please carefully enter the correct code as instructed.

You log in to PhpMyAdmin, select the database you are using, click the SQL tab and paste the code below, press Go (execute). When that default password you set is: bachkhoatoanthu24h

UPDATE xf_user_authenticate
SET data = BINARY
CONCAT(
CONCAT(
CONCAT(‘a:3:{s:4:”hash”;s:40:”‘, SHA1(CONCAT(SHA1(‘ bachkhoatoanthu24h’), SHA1(‘salt’)))),
CONCAT(‘”;s:4:”salt”;s:40:”‘, SHA1(‘salt’))
),
‘”;s:8:”hashFunc”;s:4:”sha1″;}’
),
scheme_class = ‘XenForo_Authentication_Core’
WHERE user_id = 1;

Go to site, sign in Nick Admin (Nick Admin Number 1) to enjoy the.