Discuz Forget the administrator password solution

Turn from here:

I do the forum website and so on, the number of more after the general will neglect management often because of long time without login and forget the password, this forum I forgot several times
Because I don't know about discuz, I thought I could just modify the password field of the user table.
But tried many times still failed, began to think that the method of encryption is wrong, the original need to modify three data tables, 囧RZ
So a new user was created locally, and the password was copied and still failed.

On the official website for half a day and did not find a password tool to use
And then finally found a way to modify it by phpMyAdmin.

Execute the following SQL statement
User name: admin password: 780304


x2.5/3.1 version password Modify SQL code
UPDATE IGNORE ' pre_common_member ' SET ' uid ' = 1, ' email ' = ' admin@admin.com ', ' username ' = ' admin ', ' password ' = ' dc3ca11de97 ' E974a450ac978c5f01bd8 ', ' status ' = 0, ' emailstatus ' = 0, ' avatarstatus ' = 0, ' videophotostatus ' = 0, ' adminid ' = 1, ' groupid ' = 1, ' groupexpiry ' = 0, ' extgroupids ' = ', ' regdate ' = 1334725420, ' credits ' = Ten, ' notifysound ' = 0, ' timeoffset ' = ', ' newpm ' = 0, ' newprompt ' = 0, ' accessmasks ' = 0, ' allowadmincp ' = 1, ' onlyacceptfriendpm ' = 0, ' conisbind ' = 0 where ' Pre_common_member '. ' UID ' = 1;

UPDATE IGNORE ' pre_ucenter_members ' SET ' uid ' = 1, ' username ' = ' admin ', ' password ' = ' f69a1d5054ecc78b988bbde05b8dfb88 ', ' Email ' = ' admin@admin.com ', ' myid ' = ', ' myidkey ' = ', ' regip ' = ' hidden ', ' regdate ' = 1334725417, ' lastloginip ' = 0, ' Lastlog Intime ' = 0, ' salt ' = ' 97b07d ', ' secques ' = ' WHERE ' pre_ucenter_members '. ' UID ' = 1;

UPDATE IGNORE ' pre_ucenter_admins ' SET ' uid ' = 1, ' username ' = ' admin ', ' allowadminsetting ' = 1, ' allowadminapp ' = 1, ' Allowad Minuser ' = 1, ' allowadminbadword ' = 1, ' allowadmintag ' = 1, ' allowadminpm ' = 1, ' allowadmincredits ' = 1, ' allowadmindomain ' = 1 , ' allowadmindb ' = 1, ' allowadminnote ' = 1, ' allowadmincache ' = 1, ' allowadminlog ' = 1 WHERE ' pre_ucenter_admins '. ' UID ' = 1; Copy Code
This should be possible, if the hint still fails, wait 15 minutes and then log back in
Do not forget to change the password after successful login Oh ~