back to phpList.org

Mysql password reset for admin


#1

Can someone tell me is we use the sha, MD or what is the right way to update the password for the admin user so I can log back in. Thanks


#2

If you want to modify the admin database table directly then the hash algorithm to use is sha256.


#3

Also you can set a new plaintext password in the db directly, and this will be detected and automatically secured and rewritten the first time phpList is initialised afterwards.


#4

I will try the plaintext can someone pass the right command I will check for the sha256 which I tried to set but that did not work form me. Thanks


#5

ok this works:

update phplist_admin SET password=‘mynewpasswordworks’ where id = 1;