How to reset Prestashop Backend’s admin password using mysql command ?
mysql -u <username> -p<password> <database> -e "UPDATE ps_employee SET passwd = MD5('<cookie_key><password_you_want_to_setup>') WHERE ps_employee.id_employee = 1
you can get the cookie_key from file stored at config/settings.inc.php
for ex-: If you want to reset the password as [email protected] then you have to execute the following -:
mysql -u root -ppasscode prestashop -e "UPDATE ps_employee SET passwd = MD5('[email protected]23') WHERE ps_employee.id_employee = 1"