Content
Open your cPanel and go to phpMyAdmin.
Select the database of your PrestaShop application.
If you are not sure which database your PrestaShop 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 File Manager in cPanel.
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.
|
1
|
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 [email protected] the query should look like the following:
|
1
|
UPDATE `employee` SET ‘passwd’ = md5(concat(‘123’, ‘abc’)) WHERE email = “john@smith.com”;
|
If the SQL query was executed correctly you will be able to access PrestaShop with that user and the new password.
