网络营销电子商务研究中心 - How to manually reset a password in vBulletin?

网络营销电子商务研究中心 (https://www.0058.net/index.php)

- vBulletin技术交流 (https://www.0058.net/forumdisplay.php?f=6)

- - How to manually reset a password in vBulletin? (https://www.0058.net/showthread.php?t=5212)

Iaeger

2015-07-17 10:30 AM

How to manually reset a password in vBulletin?

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

2015-07-17 10:31 AM

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

2015-07-17 10:32 AM

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:

Code:

UPDATE `user`

SET `password` = MD5(CONCAT(MD5('newpassword'), `user`.`salt`))

WHERE `userid` = 1

Ensure you have the correct userid!

All times are GMT +8. The time now is 10:43 AM.