Update Admin Password in Database in Prestashop 1.7

If you want to change or update your backoffice admin user password in Prestashop you need to execute the following query:

UPDATE bo_employee SET passwd = md5("<COOKIE_KEY><newpassword>") WHERE email = "<admin_email>";

The <COOKIE_KEY> field has to be changed by the value of the ‘cookie_key’ line in the app/config/parameters.php file.