Tables related to users and passwords:
1) pre_common_members, pre_ucenter_members
2) The password in the Pre_common_members table is only a one-time MD5 encryption of the random code, when the user logs in does not use the Web login password only related to the Pre_ucenter_members table
1. User user1 forgot password, login not; re-register a new user named Usertest, password set to 12345678
Description: Taking into account the complexity of encryption, the use of password override method
650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/8D/6C/wKioL1icFnmwlUlIAADYUBRa8Wo355.png "title=" 1.png "alt=" Wkiol1icfnmwluliaadyubra8wo355.png "width=" 650 "style=" Padding:0px;margin:0px;vertical-align:top;border: none; "/>
2. Use the database tool navicat for MySQL login discuz database, view pre_ucenter_members table, get to
Password, salt value for user usertest
Description: Usertest after two times MD5 encryption, non-plaintext
password:7f08d654bc1baef5c810ede044fb677c
Salt:6950e2
650) this.width=650; "src=" Http://huangzp.blog.51cto.com/e/u261/themes/default/images/spacer.gif "alt=" spacer.gif "style=" padding:0px;margin:0px;vertical-align:top;border:1px solid rgb (221,221,221); Background:url ("/e/u261/lang /zh-cn/images/localimage.png ") No-repeat Center;"/>650) this.width=650; src= "Https://s5.51cto.com/wyfs02/M00/ 8d/6f/wkiom1icfoqtni6xaabtgvzu4xc721.png "title=" 2.png "alt=" Wkiom1icfoqtni6xaabtgvzu4xc721.png "style=" padding:0 Px;margin:0px;vertical-align:top;border:none; "/>
3. Update the password and salt values of user User1 with MySQL statement, and be consistent with user Usertest
Statement 1:
UPDATE pre_ucenter_members SET password = ' 7f08d654bc1baef5c810ede044fb677c ' WHERE username = ' User1 '
Statement 2:
UPDATE pre_ucenter_members SET salt = ' 6950e2 ' WHERE username = ' User1 '
650) this.width=650; "src=" Http://huangzp.blog.51cto.com/e/u261/themes/default/images/spacer.gif "alt=" spacer.gif "style=" padding:0px;margin:0px;vertical-align:top;border:1px solid rgb (221,221,221); Background:url ("/e/u261/lang /zh-cn/images/localimage.png ") no-repeat Center;/>
650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/8D/6C/wKioL1icFpnT7hutAAA_kaKhrtI915.png "title=" 3.png "alt=" Wkiol1icfpnt7hutaaa_kakhrti915.png "width=" 650 "style=" Padding:0px;margin:0px;vertical-align:top;border: None;float:none; "/>
650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/8D/6F/wKiom1icFpuhBuKYAAAx1lRRfj0820.png "title=" 31. PNG "alt=" Wkiom1icfpuhbukyaaax1lrrfj0820.png "style=" padding:0px;margin:0px;vertical-align:top;border:none;float : none; "/>
650) this.width=650; "src=" Http://huangzp.blog.51cto.com/e/u261/themes/default/images/spacer.gif "alt=" spacer.gif "style=" padding:0px;margin:0px;vertical-align:top;border:1px solid rgb (221,221,221); Background:url ("/e/u261/lang /zh-cn/images/localimage.png ") no-repeat Center;/>
4. View the Pre_ucenter_members table again, updated successfully
650) this.width=650; "src=" Http://huangzp.blog.51cto.com/e/u261/themes/default/images/spacer.gif "alt=" spacer.gif "style=" padding:0px;margin:0px;vertical-align:top;border:1px solid rgb (221,221,221); Background:url ("/e/u261/lang /zh-cn/images/localimage.png ") No-repeat Center;"/>650) this.width=650; src= "https://s3.51cto.com/wyfs02/M01/ 8d/6f/wkiom1icfq7cnxruaabiz1qx7hi390.png "title=" 4.png "alt=" Wkiom1icfq7cnxruaabiz1qx7hi390.png "style=" padding:0 Px;margin:0px;vertical-align:top;border:none; "/>
5. User name User1, New Password 12345678, login successful again
650) this.width=650; "src=" Http://huangzp.blog.51cto.com/e/u261/themes/default/images/spacer.gif "alt=" spacer.gif "style=" padding:0px;margin:0px;vertical-align:top;border:1px solid rgb (221,221,221); Background:url ("/e/u261/lang /zh-cn/images/localimage.png ") No-repeat Center;"/>650) this.width=650; src= "https://s5.51cto.com/wyfs02/M01/ 8d/6c/wkiol1icfr3ths-taaezy1e5pfg007.png "title=" 5.png "alt=" Wkiol1icfr3ths-taaezy1e5pfg007.png "width=" 650 "style = "Padding:0px;margin:0px;vertical-align:top;border:none;"/>
Discuz Forum forgot login password, MySQL solution