[Prestashop][Reset][EN]After finished Prestashop installation, sometimes you might forgot your administrative password, how should you do?

After finished Prestashop installation, sometimes you might forgot your administrative password, how should you do?

            Usually, when the Prestashop has been finished installation, it recurrently problem after finished was you have forgot your password or your own password were incorrect, therefore, the KEY of Prestashop has changed on new website so that you could not login from your password.

How to be solved the problem.

You could solve the problem via SQL Command to reset the password in order to using from this structure.

UPDATE ps_employee

SET passwd = MD5('<_COOKIE_KEY_>password')

WHERE ps_employee.id_employee = 1;

<_COOKIE_KEY_> using the key from path \config\settings.inc.php  it was appeared as below

define('_COOKIE_KEY_', 'bVW1yoNBuNjYOgJKBAbFVr9CWCFPb02LY86SThwhaL0R8GP0v78SaV0f');

UPDATE ps_employee

SET passwd = md5('<_COOKIE_KEY_>newpassword')

WHERE ps_employee.id_employee = 1;

Using MD5, you could be created with the key combines [newpassword] so that you used with fuction MySQL or function via PHP which one you do like.

UPDATE ps_employee

SET passwd = md5(' 'bVW1yoNBuNjYOgJKBAbFVr9CWCFPb02LY86SThwhaL0R8GP0v78SaV0f newpassword')

WHERE ps_employee.id_employee = 1;

In order that you used WHERE filter command via MySQL you chose [ id_employee = 1] so that ID from Admin, If you wanted to reset other employee, you could reset password similar to Admin step.

Good luck to you.