How to reset PrestaShop Admin Password

If for some reason you've forgot your admin password and because of a faulty update the email you receive with the password reset is bad you can do the following sql command

1. UPDATE employee SET passwd = md5("COOKIE_KEYpassword_here”) WHERE email = “email_for_who_you_want_to_change_the_password”;

You can find the COOKIE_KEY in config/settings.inc.php

Remember that the password must be greater than 8 characters in length and that it has to be put without spaces to the right of the COOKIE_KEY value.