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.