This tutorial will guide you through the process of changing the Magento password using phpMyAdmin. Use this method if you are unable to access the admin panel of the website or if you have not received a password reset link via email.

Changing the Magento Administrator Password

1) Log in to your cPanel account, navigate to phpMyAdmin, and select the Magento database. After selecting the database, you will see all the tables within it. Choose the “admin_user” table, as shown in the screenshot below.

2) Now, we will modify the password for the “admin” user. Click on “Edit” next to the “admin” user, as shown in the following screenshot.

3) Enter your desired password (e.g., “KfhUCwTS1ptGE”). Additionally, add a two-character sequence called “cryptographic salt” in front of the password. The salt can be any two characters. In this example, the salt is “tu”. After adding the salt, select MD5 encryption and click “GO” to save the changes.

4) Once the changes are saved, edit the password again by adding the salt at the end, as shown in the following screenshot. Save the changes by clicking “Go”.

Congratulations! You have successfully updated the password for the admin user. You can now access the Magento admin panel using the new password.

If you require further assistance, please reach out to our support department.