Step 1: Login to your cPanel account.
Step 2: Go to PhpMyAdmin under Databases.
Step 3: If you are not sure which database your PrestaShop is using you can check the config/settings.inc.php file and see the value of _DB_NAME_, which looks similar to the following:
+++
define(‘_DB_NAME_’, ‘your_db_name’);
+++
Step 4: You can open the file through File Manager in cPanel.
Step 5: Once you have selected your database, click the SQL button from the top menu to run the following SQL query and replace the <> variables with your information.
Step 6: If the SQL query was executed correctly you will be able to access PrestaShop with that user and the new password.
How to reset the password in my PrestaShop
Need Support?Contact Support