网络营销电子商务研究中心

网络营销电子商务研究中心 (https://www.0058.net/index.php)
-   vBulletin技术交流 (https://www.0058.net/forumdisplay.php?f=6)
-   -   admin password reset in phpmyadmin, how to? (https://www.0058.net/showthread.php?t=5066)

Hagaman 2015-03-31 12:45 PM

admin password reset in phpmyadmin, how to?
 
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.
-------------
for example:

UPDATE forums_user SET PASSWORD = MD5( CONCAT( MD5( 'jacklee' ) , salt ) ) WHERE userid =1


All times are GMT +8. The time now is 07:48 PM.

Powered by vBulletin Version 3.8.7
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.