How to manually reset a password in vBulletin?

[Iaeger]

Hi,

How do i reset my password in phpmyadmin? i know to go to user table but it wont allow me to type in my new password but instead has something like a char32 code. How can i change my password so it is in that code. is there a website thats allows words to be converted into char32?

[Ibapah]

UPDATE <prefix>user
SET password = MD5(CONCAT(MD5('new-password'), salt))
WHERE userid = X

...with 'X' being your userid number and <prefix> being your table prefix.

[Iberville]

If you are the admin of your vBulletin forum and have access to the database, you can change the password for any user (including yourself) by issuing the following sql query:

UPDATE `user`
SET `password` = MD5(CONCAT(MD5('newpassword'), `user`.`salt`))
WHERE `userid` = 1


Ensure you have the correct userid!