Reset Prestashop admin password

On Prestashop 1.7, open file

app/config/parameters.php

Find the value of “cookie_key”.

Find admin user with the command

select * from ps_employee;

This list all employee accounts. Find the email of the user you need to reset password

Now run the following SQL

update ps_employee set passwd=MD5("<cooie_key><NEW_PASSORD>") where email="[email protected]";

Here <cooie_key><NEW_PASSORD> is the combination of cookie_key and your new password. If your cookie key is ttVfw3V5mL7zJBk5QozFjuunN6u4wAkBcgydLFHd4d5hRzPpKjOb4Ohk and you need to reset your password to 2v1PSXa5MO6txmLd, use following command:

Example

update ps_employee set passwd=MD5("ttVfw3V5mL7zJBk5QozFjuunN6u4wAkBcgydLFHd4d5hRzPpKjOb4Ohk2v1PSXa5MO6txmLd") where email="[email protected]";

This set the password for the admin user “[email protected]” to “2v1PSXa5MO6txmLd”.

See Prestashop