MilesWeb
MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length

 

News:

SMF - Just Installed!


Author Topic: How To Reset Magento Admin User password Using phpmyAdmin?  (Read 2936 times)

0 Members and 1 Guest are viewing this topic.

Offline Dipak Bhoi

  • MilesWeb Team Member
  • Full Member
  • ***
  • Posts: 208
  • Karma: +5/-0
    • View Profile
    • MilesWeb Internet Services
How To Reset Magento Admin User password Using phpmyAdmin?
« 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.

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

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


Quote
Looking for quality Magento hosting? Look no further than MilesWeb Magento Hosting.
« Last Edit: December 08, 2016, 08:39:38 PM by Turkey »
MilesWeb.com
cPanel Hosting in India - cPanel Hosting in India.

Grab an SSL for your website and SAVE 20% now. Coupon Code SSLSAVE20.

MilesWeb Hosting Forum

How To Reset Magento Admin User password Using phpmyAdmin?
« on: March 06, 2015, 02:34:02 PM »