Recovering Administrator Access on Your Prestashop Site
If you have lost your administrator password for your site, this article will help you recover access. The way most content management systems (CMS) stores authentication data, is within a MySQL database table usually named “user.” Passwords are usually encrypted using one way hashing algorithms such as SHA2 and sometimes made difficult to brute force with key derivation functions or salting. Some CMS have tools that you can use via SSH, and others require that you modify the database directly. This article will explain how you can reset the password for Prestashop.
Using phpMyAdmin to run a query
In this article, there are many steps that require running a MySQL query on the database for your web site. If you are unfamiliar with MySQL, we recommend that you pay close attention when entering the query or contact us for assistance as you are able to cause damage to the site if a query is entered incorrectly. This section will provide instructions on how to run the queries mentioned in this article with the use of phpMyAdmin built into cPanel.
Before you run any query, first make sure that you are running the query on the correct database and that you have updated or added correct prefixes to the tables mentioned in a query. You can find this information by viewing the configuration file for the site, which contains the database name and table prefix.
UPDATE `prefix_users` SET `user_pass` = MD5(‘password’) WHERE `user_login` = ‘admin’;
The query above will change the password for the user “admin” to the password “password” on a CMS. Before you run the query, you must first update the query to match your environment. The prefix, identified as “prefix_” in the example, needs to be either removed or replaced depending on if your site uses a prefix. The password needs to be replaced. The username needs to be updated to your account login-if you do not know the account login, you can usually click on the table in phpMyAdmin to see what accounts exist.
Note: If you are copying and pasting the query, double check the single quotes (‘) and prime (`) are not replaced with smart quotes. The prime key is to the top left of the keyboard under the escape key and the single quote key is next to the return key typically on a us keyboard.
Once you have all the information above updated to match your environment, you can then run the query on the database.
- Login to cPanel.
- Under the databases section, click on phpMyAdmin.
- On the left side bar, click on the database for your site.
- On the top, click on the tab named SQL.
- Confirm that the “Run SQL query/queries on database user_db” matches the database name of your site.
- Enter the query, updated to match your environment.
- Once you have confirmed everything is right (you can click simulate query to see how many items will be affected), click on the “Go” button on the bottom right to execute the command.
- View the configuration at “config/settings.inc.php” and copy the “_COOKIE_KEY_” (example: rwhsrmrfoppmrxbzud3cw365xr28rpzf47h21g6q).
- Follow the instructions above to run the following query in phpMyAdmion. Be sure to replace the example cookie key and password.
UPDATE `prefix_employee` SET `passwd` = MD5(‘rwhsrmrfoppmrxbzud3cw365xr28rpzf47h21g6qpasswd’) WHERE `email` = ‘[email protected]’;
- Login to Prestashop with your new password.
- Run the following query to set the password to “password” in phpMyAdmin.
UPDATE `prefix_employee` SET `passwd` = ‘$2y$10$3TTA/yRF6XIBtmSzOxBIHO99qBGLT.1M35fb/Hki2PClsuXMuS3pa’ WHERE `email` = ‘[email protected]’;
- Login to Prestashop with your email address and “password” for the password.
- On the top right, click on the user menu and go to your profile.
- Click on change password and enter “password” for “Current password” and a new password in “New password” and “Confirm password” fields, or click on “Generate password” to get a unique password.
- Click “Save” on the bottom right of the page.