参考：https://enxf.net/threads/some-useful-xenforo-mysql-queries.5151/

Query to replace the searched phrase with a different phrase in all messages

UPDATE xf_post
SET
message = REPLACE(message, 'old words', 'new words');

Password reset with SQL query

UPDATE xf_user_authenticate
SET data = BINARY
CONCAT(
CONCAT(
CONCAT('a:3:{s:4:"hash";s:40:"', SHA1(CONCAT(SHA1('new password'), 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;