discuz忘记管理员密码解决办法

我们平时做的论坛网站之类的，数量多了以后，普遍都会疏于管理经常会因为长时间的不登录而忘记密码，西瓜就忘了好几次了
由于对discuz不了解，我以为只修改用户表的密码字段就可以了
但是尝试了好多次都依然失败，开始以为是加密的方法不对，原来需要修改三个数据表，囧rz
于是就在本地新建了一个用户，把密码复制进去，依然失败

在官网找了半天也没有找到能用的密码工具
后来终于发现一个通过phpmyadmin修改的方法

执行以下SQL语句（使用用户名：admin 密码：780304）

2.5/3.1版本密码修改sql代码

1. UPDATE IGNORE pre_common_member SET uid = 1,email = 'admin@admin.com',username = 'admin',password = 'dc3ca11de97e974a450ac978c5f01bd8',status = 0,emailstatus = 0,avatarstatus = 0,videophotostatus = 0,adminid = 1,groupid = 1,groupexpiry = 0,extgroupids = '',regdate = 1334725420,credits = 10,notifysound = 0,timeoffset = '',newpm = 0,newprompt = 0,accessmasks = 0,allowadmincp = 1,onlyacceptfriendpm = 0,conisbind = 0 WHERE pre_common_member.uid = 1;
2. UPDATE IGNORE pre_ucenter_members SET uid = 1,username = 'admin',password = 'f69a1d5054ecc78b988bbde05b8dfb88',email = 'admin@admin.com',myid = '',myidkey = '',regip = 'hidden',regdate = 1334725417,lastloginip = 0,lastlogintime = 0,salt = '97b07d',secques = '' WHERE pre_ucenter_members.uid = 1;
3. UPDATE IGNORE pre_ucenter_admins SET uid = 1,username = 'admin',allowadminsetting = 1,allowadminapp = 1,allowadminuser = 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;

这样应该就可以了，如果依然提示失败，就等15分钟再重新登录
登录成功后别忘记 修改密码哦～