How to reset the password in my PrestaShop?

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.

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:

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

You find this article useful? Click here to learn more about SiteGround web hosting experts and what else we can do for you!