The administrator password can also be recovered through the Prestashop database. This should only be done when the super administrator password has been lost and can only be recovered manually.  The following article shows how to manually recover the password in PrestaShop 1.5 using phpMyAdmin. 

 

Manually Creating a New Password in the PrestaShop 1.5 Database

  1. Start by logging into your Cpanel account.

    passwords-cpanel-logged-in


  2. You will need to first acquire the Cookie key which can be found in the SETTINGS.PHP file in your PrestaShop installation directory. Open the File Manager in Cpanel and then go to the CONFIG folder found in your PrestaShop 1.5 installation directory.  The screenshot below shows the CONFIG folder contents in the column at right:

    passwords-config-file-mngr

  3. Find the SETTINGS.PHP file, then click on it and select EDIT in order to edit the file.  Note: we are NOT making changes to this file - we are only recording the D Highlight the cookie key (it will be a long string of numbers and letters) and then right-click on it with your mouse and select COPY.  Do not hit a key on your key board when you have the key highlighted, or it will change the file.  If you do this accidentally, simply close the file and then re-open it WITHOUT SAVING the file.  When you open the SETTINGS.INC.PHP file, you will see the code as per below:

    passwords-edit-text

    Note that only a portion of the file is showing.  The code includes the cookie key for o
  4. Open a blank text file on your desktop (you can use notepad, or if you're on a Mac, use textedit).

  5. Right-click in the blank text file and paste the cookie text into it.  If you don't use copy and paste for this state, you can always attempt to write down all 55+ characters.

  6. After having copied the code, you've completed the initial steps.  Highlight the cookie key. 

  7. Paste the cookie key into the blank notepad or and then go to the next step.  Leave this window open.

  8. Go back into your CPANEL and then go to the DATABASES section.  Click on PHPMYADMIN order to start it up.

    passwords-phpmyadmin


  9. Select the database that is being used for your PrestaShop installation.  Click on it, and you will see all of the tables listed for the application. You will need to specifically look for the ps_employee table.


  10. Click on EDIT for the user where the password must changed.  In the password field, copy and paste the COOKIE KEY you copied earlier.  Then type in your new password. 

  11. You will next need to go to the FUNCTION column  and choose MD5 from the drop-down menu. 

  12. Select GO in order to commit the password change.

 

This option to change the password bypasses the normal interface and should only be used when you have no other choice.  Remember that in order to use this method you will need to have access to the database.  Security for all passwords should be considered of utmost importance and you should practice good habits such as regular password changes and longer passwords using a non-familiar combination of letters and numbers.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve our Help Center:
Email Address
Optional, but our team may contact you for more information.
Did you find this article helpful?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.