PrestaShop & php: change admin password in database

Trabla: PrestaShop: change admin password in database

Solving:

1. Get your Presta __COOKIE_KEY__  value, is used for password encryption
Find file settings.inc.php , located in  :
.../prestashop/config/settings.inc.php

Example:

...
define('_MEDIA_SERVER_3_', '');
define('_COOKIE_KEY_', 'aHDAUqwDov63vIkCo4vKUrg0edcA7z0EM6O9rtVnd8BzBGMQqzE2Jbta');
define('_COOKIE_IV_', '1ctPsmVv');
...

2. Execute query in database ( replace red values by yours )

Note: ps_  is table prefix, can be different

UPDATE ps_employee 
SET passwd = md5( 
    CONCAT(
      <COOKIE_KEY> ,  <NEW_PASSWORD>
    )
 ) 
WHERE email = <ADMIN_EMAIL> ;



Example:

UPDATE ps_employee 
SET passwd = md5( 
    CONCAT(
      'aHDAUqwDov63vIkCo4vKUrg0edcA7z0EM6O9rtVnd8BzBGMQqzE2Jbta' ,   
      'pass1234$%'
    )
 ) 
WHERE email = 'admin@mymail.com' ;