How to reset Admin password using phpMyAdmin in Magento

Sometimes you forget your Magento Admin password and you don’t know how to reset or recover it? This magento tutorial will guide you step by step how to set a new password for your Admin account using phpMyAdmin.

Step 1: Access phpMyAdmin tool

If you are using Cpanel, you can access phpMyAdmin in Database section

In case you’re not using Cpanel, you can access phpMyAdmin directly from your domain, just follow these steps:

– Download latest compatible phpMyadmin version at: https://www.phpmyadmin.net/downloads/

– Exact the compressed package, upload the files to your desired path, for example, if your site’s folder is Public_html you can upload to:  public_html/phpmyadmin/

– Next, access phpMyAdmin directly from this url: youdomain.com/phpmyadmin/

Note:(sometimes you cannot access phpmyadmin due to htaccess file, just temporarily rename/remove the file to access phpmyadmin)

– Now login using Cpanel account info or any mysql user you created.

Step 2: Access database

Now select the database of your site on the left side

Step 3: Create new admin account for Magento site

After that, click on the SQL tab in and execute the following MySQL query:

Change the following variables:

admin_user – this is database table from the Magento database. Check if this table have a prefix , such as “bk_“, you need to replace the admin_user name with the correct database table name, i.e. bk_admin_user.

NEWPASSWORD – the new password which you want to set.

ADMINUSERNAME – Magento admin username, i.e. admin.

Click on Go button to run the query and your new admin account will be set.

*if you see many databases in phpMyadmin and not sure which one is being used on your site, open the following file:

~/app/etc/local.xml

And search for the following line:

user_magedatabase is the name of the database of your Magento site

Everything is done, now just login with the newly created admin account.

Leave a Reply

Your email address will not be published. Required fields are marked *