Reset PrestaShop admin password through the MySQL

Reset your PrestaShop password through the MySQL database using the phpmyadmin tool in cPanel.

1. Login to phpmyadmin and select the Prestashop database for which you want to change admin password.

If you don’t know which database then check configuration file is placed in this config folder under the name of Open it and get the database name from there (you may find it in the _DB_NAME_ field).

You also need to copy-paste the _COOKIE_KEY_ from this page( You will need it later for the password resetting:

2) Find the ps_employee table and click on it: Now you see the users list. Choose the user you need and press Edit: 

In the passwd line choose MD5 from the drop-down menu. Copy-paste the _COOKIE_KEY_ from your file into the Value field.

Once the key is copy-pasted, please scroll to the end of the line and enter your password right after the key, without the space after the key. Press Go:

That’s it!


Developer, Technology aficionado, Beer Lover and founder of Network. Who shares a keen interest about website development, health issues, cancer awareness and other fun stuff.

Add comment

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.

Most popular

Most discussed