Reset Prestashop 1.6 admin password

To reset admin password for prestashop 1.6 or below, find value of _COOKIE_KEY from file

The line look like

Now you need to update ps_employee table using following SQL command.

Replace “YOUR_NEW_PASSOWRD_HERE” with your new password.

ps_employee maybe differnt depending on what table prefix you selected during prestashop installation.

id_employee=1, change this with id_employee of the user you need to change password. 1 is id for first user.

Once password reset, you will be able to login to admin area. Normally prestashop rename admin folder to random name, this you can find it in FTP as it is just a normal folder.

prestashop reset admin password

Reset Prestashop admin password

On Prestashop 1.7, open file

Find the value of “cookie_key”.

prestashop reset admin password

Now run following SQL


This set password for admin user [email protected] to “ok123pass”.

See Prestashop

Prestashop Change URL

To change domain name of a Prestashop site, you need to edit MYSQL database.

Table ps_configuration

Value for following should be changed to new domain.


Table ps_shop_url

Change “domain” and “domain_ssl” value.

Changing Installation Folder

If you changing Prestashop installation folder, then you need to change “physical_uri” to new path. If it is on root directory, use /

Here are SQL commands to change URL of prestashop to “prestashop.test”