@@@@ SPOILER/ANSWER @@@@
UPDATE user
set password = MD5(concat(MD5('<NEWPASSWORD>'), user.salt))
WHERE userid = <USERID>
@@@@@@@@@@@@@
What query will allow me to reset my admin password directly in the database?
Please don't tell me to use the lost password function or the tools.php as neither has worked for me yet.
I've tried:
mysql> UPDATE forum.user SET password=MD5('n3wpasswd') WHERE userid = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Is the password seeded or ??
Thanks
bTal
UPDATE user
set password = MD5(concat(MD5('<NEWPASSWORD>'), user.salt))
WHERE userid = <USERID>
@@@@@@@@@@@@@
What query will allow me to reset my admin password directly in the database?
Please don't tell me to use the lost password function or the tools.php as neither has worked for me yet.
I've tried:
mysql> UPDATE forum.user SET password=MD5('n3wpasswd') WHERE userid = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Is the password seeded or ??
Thanks
bTal
Comment