Samsung Galaxy Note, 4G LTE Plans, Transfer Photos Videos from iPhone to Samsung, Network Performance, Mobile Accounts, Furious Gold SPD TooL, Latest Version Full Setup

Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP

Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP - this blog we have built from a few years ago and already very much information about gadgets that we convey and a lot of blog visitors New Blog Techno News who are satisfied with the information, we will always try to update the latest information for you, first about Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP many already we collect data to make this article so you do not miss the news, please see:

Articles : Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP
full Link : Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP

You can also see our article on:


Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP

In Magento local installation using XAMPP/WAMP, whenever we enter the wrong password, the Magento admin panel won't let us log into our application backend. The 'forgotten password' link  does not work because the application is installed locally and the local server is not capable of sending us the email message with our password. Fortunately, we have the liberty to reset forgotten password using phpMyAdmin.

Forgot Password :-

1. Firstly, Log into your phpMyAdmin dashboard. Select the 'magento' database. 


2. Click on the SQL tab on top. Enter the following line of SQL query. Enter your desired new password and your current username in place of  'PASSWORD' and 'USERNAME'. Please note that you need to know your correct username for this.  

UPDATE `admin_user` SET `password` = MD5('PASSWORD') WHERE `username` = 'USERNAME';

Hit Go.




3. By following the above method we are directly manipulating the password field in the MySQL database of Magento. We are making changes in the 'admin_user' table. Please note that this will work only when the default function used by Magento framework for password encryption hasn't been tweaked with. The default function is md5. If you haven't touched the settings for changing it, this solution will work for you.  

4. Try logging in with your new password to Magento admin panel. It should work now. 

Forgot Username :-

The procedure for resetting or changing the username is same as changing the password except for the SQL query part. In this case run this query with your password as it is and new username.

I have tested this solution for Magento installation Version 1.9.2 and XAMPP installation version 5.6.3.





articles Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP finished in discussion

hopefully the information we convey about Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP can benefit you in getting new knowledge about technology,

you just finished reading the information Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP we hope this informmation can answer the question you submit to googlle, if you want to bookmark or share please use link https://moymoycikukecik.blogspot.com/2016/04/info-how-to-reset-password-and-username.html and do not forget to always visit this blog to get the latest information every day.

Tag :
Share on Facebook
Share on Twitter
Share on Google+
Tags :

Related : Info How to reset password and username for Magento admin panel from phpMyAdmin XAMPP

0 komentar:

Posting Komentar