Cloudkul Support

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/

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"


Is this article is helpful?

People like and 0 people dislike.

If result is not found or irrelevant, Please contact us.

Submit your request