There are times when you may forget your password. In these instances, you can have the admin password changed via email. If, for some reason, you do not receive the email for the new password, you will not be able to log into the admin area with it. There is a fix, however. You will need to change your password by modifying the database directly. This can be a bit awkward and intimidating, however following the steps below should allow you to change your admin password in your PrestaShop 1.5 database without any trouble.

This article assumes you are using a hosting account that uses cPanel software for managing your hosting account.

Modifying your admin password via database in PrestaShop 1.5.

  1. First you will need to log into the cpanel for your hosting account.
  2. Once logged in, you will need to locate the File Manager, found in the Files category, and click on the icon.
    file-manager
  3. You will then need to pick your entry point into the file manager. If you have your PrestaShop as your main site, select the Web Root option. In our case, it is a subdomain, so we selected that option in the Document Root For dropdown and selected that option. Click on the Go button to continue to the files.
    select-folder
  4. Once in the File Manager, find anc double click on the config folder. This will take you to a list of all files within that folder.select-config-folder
  5. Look for the settings.inc.php file. Highlight it by clicking on it once. Then, using the icons across the top, find and click on the Code Edit feature. Click Edit from the pop up that will appear to continue.
    select-settings-file
  6. Once inside the settings.inc.php file, locate the setting named _COOKIE_KEY and copy the string. You can see the area below that we highlighted. You may want to save it temporarily to a word processing document such as notepad, notepad++, MS Word, etc. Close the file once you have the key.
    select-cookie-key


  7. Go back to your cPanel and find the Databases category. From there, click on the PhPMyAdmin tool.
    select-phpmyadmin
  8. Once inside, select (click on) the correct database for your PrestaShop 1.5 application from the list of databases on the left hand sidebar.

  9. You will then see a list of the database tables in the left sidebar. Scroll down and select the one named ps_employee.

    Note that your PrestaShop database prefix might not begin with ps_

    select-table
  10. This opens the table data information. Find your admin user from the list of data rows and click on the Edit link on the right side of that particular row.
    select-admin-data-row
  11. Find the password row, it is named passwd. There are two columns you will need to edit. The first is the Function column. Use the dropdown and select the MD5 option. The second column is the Value column. For this column, paste the _COOKIE_KEY value you saved earlier and attach your new password directly to the end of the key with no spaces. Be sure to use a real password and not anything easy like NEWPASS1234 that we used in the example.
    enter-password
  12. After you have entered the new password, scroll down to the bottom of the page and click the GO button to save the new information.


    You should now be able to log into your admin area with your new password.
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 this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Like this Article?

Comments

Post a comment
n/a Points
2014-03-01 7:02 am

tanx tanx tanx ................

n/a Points
2014-05-20 9:41 am

Hi all,

After i did reset via the database as per above article and using the LostPassword feature, it does not solve the problem. The error still persists, strangely my employee database looks good.

Pls reply if you encountered same thing or if you have solution. Appreciate. Thanks

 

Staff
7,372 Points
2014-05-20 9:54 am
I noticed that you posted a question about this as well. The answer to your question may be found at the following:
cannot login at back-office prestashop
n/a Points
2014-05-20 10:25 am

Still not working Jeff. Even, the support guy tried the same thing on my behalf. They still can't get it worked :(

Staff
15,308 Points
2014-05-20 12:47 pm
Hello Andy,

I tested the above steps with different versions of PrestaShop without error. I also got in touch with the tech who worked with you this morning and the username and password you provided him allow me to sign into the back office without error. Did you get the issue fixed or was it another user that is having issues with logging in?

Kindest Regards,
Scott M
n/a Points
2014-05-20 12:56 pm

I think ofcourse you can login now, because i requested for backup restore. None of the support can fix that. Until now, I dont know what the root cause.

Staff
15,308 Points
2014-05-20 1:14 pm
Hello Andy,

I tested with the techs before the database restore where the password is located. But I am glad it is working for you now. If the errors return feel free to comment back here and I will take a deeper look at your files and database content.

Kindest Regards,
Scott M
n/a Points
2014-06-26 4:59 pm

Thanks , It works

n/a Points
2014-07-11 7:10 pm
LOVE IT. DON'T CHANGE IT. IT WORKED! AND EASY TO FOLLOW (EXCEPT ONE THING. .. NOT EVERYONE NAMES THEIR DATABASE "PS").
Staff
9,521 Points
2014-07-11 7:42 pm
Hello Bonita, and thanks for your comment.

Thank you for pointing this out, I've gone ahead and added a notice above at step 9 to clarify that your PrestaShop database might not be using the default ps_ prefix.

Thanks again!

- Jacob

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

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

News / Announcements

WordPress wp-login.php brute force attack
Updated 2014-07-17 06:43 pm EST
Hits: 200891

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!
Ask a Question

Need more Help?

Search

Ask the Community!

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

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!