Knowledgebase

Open your cPanel and go to PHPMyAdmin.

Select the database of your Presta Shop application.

If you are not sure which database your Presta Shop is using you can check the config/settings.inc.php file and see the value of _DB_NAME_, which looks similar to the following:

define('_DB_NAME_', 'your_db_name');

You can open the file through cPanel->File Manager.

Also, check the _COOKIE_KEY_ value in the same file, as you will need it in the next step.

Once you have selected your database, click the SQL button from the top menu to run the following SQL query and replace the <> variables with your information.

UPDATE employee SET 'passwd' = md5(concat('<_COOKIE_KEY_ value>', '<yourNewPassword>')) WHERE email = “youremailaddress”;

For example if your _COOKIE_KEY_ value is 123, your new password is abc and your email address is john@smith.com the query should look like the following:

UPDATE employee SET 'passwd' = md5(concat('123', 'abc')) WHERE email = “john@smith.com”;