In discuz, change the admin Password

Use discuz to create a forum. If you want to change the admin password, you can check the background settings and find that the Forum is unavailable.

The Founder's password was forgotten, and his personal login password was modified and blocked. What should I do?

Only the database is modified.

Modify the table cdb_members.

The password used in discuz is encrypted using md5 twice.

 

Create proc updateAdminPwd

As

Declare salt varchar (30)

Select set salt = salt from cdb_members where username = 'admin'

Update cdb_members

Set password = md5 (concat (md5 ('admin'), salt ))

Where username = 'admin'

 

Done !!!