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
If you want to modify the admin database table directly then the hash algorithm to use is sha256.
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.
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
ok this works:
update phplist_admin SET password=‘mynewpasswordworks’ where id = 1;