MilesWeb Hosting Forum

Web Hosting Technical Support => How To's => Topic started by: Dipak Bhoi on March 06, 2015, 02:34:02 PM

Title: How To Reset Magento Admin User password Using phpmyAdmin?
Post by: Dipak Bhoi on March 06, 2015, 02:34:02 PM
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.

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

EX ::
QuoteUPDATE `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 !! :)


QuoteLooking for quality Magento hosting? Look no further than MilesWeb Magento Hosting (https://www.milesweb.com/magento-hosting.php).