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分钟再重新登录
登录成功后别忘记 修改密码哦~ 

© 版权声明
THE END
喜欢就支持以下吧
点赞1
分享
评论 抢沙发