How to reset the password in database in Prestashop 1.7

How to reset the password in database in Prestashop 1.7

1. Navigate to /app/config folder and open the parameters.php file:

JC15ofqyqf 1024x464 - How to reset the password in database in Prestashop 1.7

or

nano app/config/parameters.php

NOTE: On PrestaShop 1.5 this key is named cookie_key and is stored in app/config/settings.inc.php

2. Under secret copy the value:

chrome 9tSeMLBX4k - How to reset the password in database in Prestashop 1.7

3. Navigate to the database inside PHPMyAdmin nad find the employee table

PJ5FpO3kPN 1024x517 - How to reset the password in database in Prestashop 1.7

4. Browse the employee table and edit the user for which you want to change the password:

xGniFemIAo 1024x517 - How to reset the password in database in Prestashop 1.7

5. Fill in the following values for passwd field:

Function:MD5
Value:The secret key we copied in step 3. and the new password
P6h1hUUAYA 1024x517 - How to reset the password in database in Prestashop 1.7

That’s it, just save and go ahead to the admin login to test the new password.

SQL QUERY

UPDATE ps_employee SET passwd = MD5('SECRETKEY+NEW-PASSWORD-HERE') WHERE ps_employee.id_employee = 1;
whoami
Stefan Pejcic
Join the discussion

I enjoy constructive responses and professional comments to my posts, and invite anyone to comment or link to my site.