Reset admin password via database problem

hello_world

Hi there,

I really need some help. Please kindly help me out!!!
I would like to find a way to reset my admin password,
cause somehow I cannot login using the old one.

I accessed the database table via phpmyadmin
in the table "pre_common_member", I pulled out the record of the admin,
in the password field, I replace the exisiting one with a new one in the
MD5 Hash format (ie. the word "admin" in the
21232f297a57a5a743894a0e4a801fc3 format).

When I go try to login again, new password doesn't work.
It seems to me that the password stored in the password field is NOT
in MD5 Hash format.

So, how can I reset the admin password inorder to be able to login
and work on the system again.

I am now now able to login the system anymore, please help.
Million thanks!

khalid

change it from UCenter table

vot

Try to use this tool:
http://codersclub.org/discuzx/fo ... amp;highlight=tools

hello_world

Hi Khalid,

Thank you very much for your kind reply.

I tried to change the password field in the table "pre_ucenter_members".
In the password field, I entered "5ebe2294ecd0e0f08eab7690d2a6ee69" (ie. the MD5 hash of the word "secret").
But I still cannot login using this new password.

My question is, is MD5 hash the right format to use in the database password field???
If not, what encryption format should I use to put in the password field.
I really need a way to reset my password.

Any of you kind help will be really really appreciated.
Many many many thanks!

vot

is MD5 hash the right format to use in the database password field???

This is wrong.
The password hash is calculated as:
md5(md5($password).$salt)

where $salt is the 'salt' field value from the 'pre_ucenter_members' table.

hello_world

Hi Vot,

Thanks so much for your help.
The "tools" works like Magic. Thanks so much!