A better way to restore prestashop admin password

Have you ever forgotten a password for your prestashop store? Or maybe you are looking for good working solution.A re you tired of trying to get to the your store back office? I think you've come to the right place :) Today we will show you a reliable way to restore your prestashop back office password . This tutorial works for all prestashop version! No matter which version you use, it will works always!

prestashop restore password


Preparing to the padlock open process - the first step in this tutorial 

For the first you must have got an access to your prestashop database. Without this it will be difficult to restore own prestashop administrator access to back office of the store. It doesnt matter what kind of software you will use, you can use phpmyadmin or  other software like mysql workbench orheidisql.

Let's start.

Ok, for the first you must go to the front office of your store. Yes! i wrote front office. If you are ready - create new customer account in your store. Customer account with correct values, Enter your password carefully, It is very important! This password will be your future password for the admin account in back office. Send the registration form and open one of the database manager and load your store table. We will show you how whole proccess looks with phpmyadmin (in most webhosting providers this is default software to manage database so you've got probably access to it).


fake prestashop account for restore admin password

We created an account for fake customer mail demo@demo.com with name Johnny Depp ;) and password pass1234


The customer database - pulling out the key to the padlock

Ok, so right after account creation for fake Johnny Depp customer, you must open your shop database in some database manager, we will use phpmyadmin to show you how it looks and what you have to do. You are looking for table called prefix_customers.  Prefix in most cases is set up to PS - so you are lookin for table named ps_customers. Open it and you will see your shop customers accounts. browse the list of accounts and find account for (in this case) Johnny Depp - it's probaby last position on list. You will see probably something like:


prestashop ps_customer table database restore admin password


All you need to do is copy (ctrl+c) passwd row value for new account. Be careful and copy it perfectly without any mistakes. It's important! if you copy it wrong - new password for your back office admin account will not work. If you are, if you are sure that you copy it right, you can go to the next step.


Insert the key into the padlock

Now you must open ps_employee table in your shop database and search for your admin account. All you need to do is paste copied passwd value to your account passwd row. Just edit this line and press ctrl+v to paste value to the field. Save changes and thats all! Now you can try to log in into back office with your admin account email and copied password, in this case we create fake account with password: pass1234. And in this case and tutorial - this is our new admin password!


ps_employee prestashop database restore password


Now you've got access to your back office again! Padlock is now open! ;)


prestashop reset admin password


after all you can of course delete fake Johnny Depp account from your ps_customer table ;)

author milos myszczuk
Article by Milosz Myszczuk PrestaShop expert, official PrestaShop community moderator. PHP developer, specialist in relative and spatial databases management, GIS Analyst, CEO & founder of VEKIA interactive agency. Read more about VEKIA company
If you like my articles and want much more valuable tips, feel free to send me donation
1.4 version 1.4.11 1.6 404 addon admin advertise ahref ajax alpha animation api app application authentication back office backup badge banner basics block bootstrap button cache carrier cart catalog category certificate changelog chat class clear client clip cms code colors columns comments configuration contact container content controller cookie counter country coupon css csv currency customer dashboard database debug default delete delivery desktop developer device disable discount displayNav displayTop download dynamic editor effect empty encrypt engine error exchange exclude export facebook faceshop fade fancoupon fancybox fanpage fatal feature feed field file fix fixed font footer free friendly url front ftp full gallery generate gift global godaddy google google+ gray grid groupon header help hide highlight homefeatured homepage hook hosting hover howto htaccess html html5 ID image import include input instagram installation integration iPhone issue javascript jquery kgb knowhow languages law left likebox link list livingsocial loading log login logo loyality mail mailing maintenance manufacturer marketing marquee mcrypt menu meta mobile modification module movie moving multilanguage multiupload must have mysql news newsletter notification number open graph order override page password performance PHP phpmyadmin picture pinterest plugin popup post prestashop prestashop 1.0 prestashop 1.1 prestashop 1.2 prestashop 1.3 prestashop 1.4 prestashop 1.5 price rules problem product profile promotion proslider purifier quantity query quick tip random rates register reinsurance release reporting reset responsive restore results ribbon rich text right sales search security seo service shadow share shipping shop shopmania slider smarty social networks SQL SSL statistics stock store style subcategory superuser support switcher tab tablet tag tax template text theme tinyMCE tips and tricks tpl tracking translations tree trends trigger tumblr tutorial twitter update upgrade upload variables video visits voucher vulnerability web2print wide widget width window wishlist wysiwyg youtube zip zopim