Posted by nick | Posted in Prestashop | Posted on Apr 14 2009
Tags: prestashop
If you’re like me and you tried the “lost password” link on prestashop’s backend and never received the email, you might try this solution if you have access to the database. Look in config/settings.inc.php for the _COOKIE_KEY_ value as you’ll need that. Run the following SQL and replace the <> variables with your information.
UPDATE employee SET passwd = md5(”<_COOKIE_KEY_ value><yourNewPassword>”) WHERE email = “youremailaddress”;
hope that helps
Thanks a lot, very useful tip.
Thanks again dude,
Thank you for tip
thank, its work great
The other way to change the password that works is:
1) Register yourself on your store with the password that you want to be the admin password.
2) Goto PhpMyAdmin >> Customer >> copy the password key from user ID you just registered.
3) Goto PhpMyAdmin >> Employee >> paste the copied key on the password column of your admin ID.
Ofcourse these are encrypted so you should not change anything while you copy paste.
Thats it
This trick works on most of the online softwares
all the best!
thanks so much!!!!!!!!!!!!!
cool dude it works
Thakssss!!!!!
copy paste rules….
thanks so much!!!!!!!!!!!!!
Men, you saved my life.
All the best from Barcelona (Spain)
Brilliant! I didnt realise that it needed the encyption key from the config.
Worked a like a charm!
Thanks Nick!
it worked for me when i was do that:
UPDATE ps_employee SET passwd = md5(”Ak7HcvPQd2VLPRrMF2BW8s7AxPe43kOL0f5zY5BDTqb0YquGLxBCcMysadmin”) WHERE email =”my@mail”
(change of coarse the MD5 and the admin at the end to your settings)
thanks man! you saved me!
well i do not understand where to put the sentences you mentioned.
I allready see a cookiekey in settings.inc. I also seen by DB password.
Should i put the words at the end?
please let me know
Excellent solution! I have been looking for other solutions but this is the best!
Thanks!
it’s work!
Many thanks and Happy New Year !
With the modification made by xile it worked. Thanx !
Thank .. Soooo much for your useful PASSWORD SURVIVAL tip. Great
and I wana tell Citra Pls.. Don’t copy ..
md5(’Ak7HcvPQd2VLPRrMF2BW8s7AxPe43kOL0f5zY5BDTqb0YquGLxBCcMysadmin’) WHERE email =’my@email.com’
and change only cookies and email,You must change all symbol ( ‘ ) in SQL statement before execute your SQL code too. It’s should work great…Thank again.
With a few modifications this worked for me
UPDATE ps_employee SET passwd = md5(’Ak7HcvPQd2VLPRrMF2BW8s7AxPe43kOL0f5zY5BDTqb0YquGLxBCcMysadmin’) WHERE email =’my@email.com’
The new password being “admin” which can be seen at the very end of the md5 checksum… Notice that single quotes are used instead of double quotes as in the first example…
Thanks so much, this worked great!
sir….your tips didn’t work for me. do you have another tips for me to reset my password for localhost installation….please help me. Thanks