How To Reset Magento Admin User password Using phpmyAdmin?

[Dipak Bhoi]

Hello folks,

If you lost the password or not remember the password of Magneto Admin user then don't worry. I have a trick for you to reset password using phpMyadmin. Just follow the below steps:

1. Login to your cPanel and access database using cPanel -> phpMyAdmin tool.

2. Once you at phpmyadmin screen,  choose database from the dropdown menu on the left side panel.

3. After that click on the SQL and run below query to reset password.

UPDATE `mg_admin_user` SET `password` = MD5('NEWPASSWORD') WHERE `username` = 'ADMINUSERNAME';

EX ::

UPDATE `mg_admin_user` SET `password` = MD5('fjs;d4sdf!') WHERE `username` = 'admin';

That's all now try to login using your new password and you should be able to login successfully.

Hope this post will help you..

Enjoy !!

Looking for quality Magento hosting? Look no further than MilesWeb Magento Hosting.