Other Applications
How to reset the password in my PrestaShop?

How to reset the password in my PrestaShop?

Go to your Site Tools > Site > MySQL > phpMyAdmin and select the database of your PrestaShop application.

If you are not sure which database your PrestaShop is using you can check the app/config/parameters.php file and see the value of database_name, which looks similar to the following:

‘database_name’ => ‘dbsao12nw0ezbumg’

You can open the file through File Manager in Site Tools.

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

Once you have selected the database, click on SQL from the top menu to run the following SQL query and replace “employee” with the table name and the cookie_key and password variables with your information.

UPDATE `employee` SET 'passwd' = MD5('cookie_key + password') WHERE `employee`.`id_employee` = 1;

For example, if the table name is soft_employee, your cookie_key value is 123, your new password is abc, the query should look like the following:

UPDATE `soft_employee` SET 'passwd' = ('123abc') WHERE `soft_employee`.`id_employee` = 1;

If the SQL query was executed correctly you will be able to access PrestaShop with that user and the new password.

Share This Article