Discuz Forum user forgot login password, MySQL solution

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 "/>

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="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= " Https://s5.51cto.com/wyfs02/M00/8D/6F/wKiom1icFoqTnI6XAABtGvzU4Xc721.png "title=" 2.png "alt=" Wkiom1icfoqtni6xaabtgvzu4xc721.png "/>

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="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/8D/6C/wKioL1icFpnT7hutAAA_kaKhrtI915.png "style=" float : none; "title=" 3.png "alt=" Wkiol1icfpnt7hutaaa_kakhrti915.png "/>

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/8D/6F/wKiom1icFpuhBuKYAAAx1lRRfj0820.png "style=" float : none; "title=" 31.png "alt=" Wkiom1icfpuhbukyaaax1lrrfj0820.png "/>

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

4. View the Pre_ucenter_members table again, updated successfully

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= " Https://s3.51cto.com/wyfs02/M01/8D/6F/wKiom1icFq7CnxRuAABiz1qx7HI390.png "title=" 4.png "alt=" Wkiom1icfq7cnxruaabiz1qx7hi390.png "/>

5. User name User1, new password 12345678, login successful again

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650 "this.width=650;" src= " Https://s5.51cto.com/wyfs02/M01/8D/6C/wKioL1icFr3THS-TAAEzy1E5pFg007.png "title=" 5.png "alt=" Wkiol1icfr3ths-taaezy1e5pfg007.png "/>

Discuz Forum user forgot login password, MySQL solution