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 hello@123 then you have to execute the following -:

mysql -u root -ppasscode prestashop -e "UPDATE ps_employee SET passwd = MD5('aSy10mKAsz1zitLksep7g9YkmFO5r5NH6BtBqvJxcwPrqz5IiO21LagqGhello@123') WHERE ps_employee.id_employee = 1"