Blog

Items filtered by date: January 2019

This method of pasword recovery will require that you be able to access both the files and the database of your PrestaShop login. The instructions will be using the cPanel File editor and phpMyAdmin in order to obtain the necessary information to reset the password that is stored in the database table.

Step 1) Login to your cPanel, then go to the FILES section and click on File Manager.

Step 2) We will need to edit the SETTINGS.INC.PHP file in order to obtain the COOKIE_KEY before we can change the password in the database. Find your PrestaShop installation files using the File Manager. When you are in the files, look for the CONFIG folder and click on it to see the list of files.

Step 3) In the file list you should see a file labeled settings.inc.php. Right-click then select EDIT or CODE EDITOR to open this file.

Step 4) When you are in the editor look for the line that begins like this: define('_COOKIE_KEY_'

. Copy the string of numbers and letters that is between the single quotation marks. Don't copy the quotation marks! In order to copy it, simply place your mouse pointer at the beginning of the text, left-click, hold the button down and drag to the end of the code. This will highlight the key. Once all of the text is highlighted, release the left button and right-click (control click on a Mac touchpad or one-button mouse) on the highlit text. Select COPY. This will store the text. You can close the file once you have the key copied.

Step 5) Go back into the cPanel and then select the phpMyAdmin icon in the DATABASES section.

Step 6) Once you have phpMyAdmin open, select your PrestaShop database name from the menu on the left side of the page. If you are unfamiliar with your PrestaShop database name then please read this article in order to find it.

Step 7) When your database opens you will see a long list of tables listed on the lefthand side of the screen. Scroll down the list of table names until you find ps_employee table> Note that this prefix may vary if it was named differently during the installation. The suffix of "_employee" should still remain though. Left-click on the table to open it.

Step 8) Select EDIT for admin employee IDOnce you have the table opened in the phpMyAdmin editor, you will need to click on EDIT for the Administrator login that you're trying to reset. Please refer to the screenshot at right to see where to find EDIT (it's to the left of the admin login that you're trying to find under Options)

Step 9) Select the passwd field and clear existing password When you are in the EDIT screen look for the line that starts with the label passwd. This is where the password is stored. You will see the existing value in the field to the right under VALUE. Click in the field, highlight all of the text and clear it with your backspace or delete key.

Step 10) Next, right click (or control-click on a Mac) in the same field and select PASTE to insert the COOKIE_KEY from the SETTINGS_INC.PHP file from earlier. If you do not see the code that you obtained earlier, please return to steps 1-4 to get the code.

Step 11) When you have finished placing the code in there, the next step is to type in your new password. There should be NO SPACE in between your password and the COOKIE_KEY. Practice good security by making sure that your password is not something easily determined. For guidelines on creating a good password, please read An Introduction to Password Security.

Step 12) Click on the drop down menu and select MD5When you have your password typed in, click on the drop-down menu to the left of the value field where you inserted the COOKIE_KEY and typed your password. It will be under the columned labeled FUNCTION. Scroll down the list and look for and select md5.

Step 13) Select MD5, double-check password and then click on GO to save password changeWhen you have selected md5, double-check to make sure your password is correct in the value field and then click on GO in the bottom left corner of the screen in order to commit the change.

Published in Prestashop