after installing magento in my local machine I forgot admin password

Question

after installing magento in my local machine I forgot admin password what I have given. I am not able to login to my admin area how can I reset the password

I have read this article http://www.atwix.com/magento/reset-admin-password-mysql/ but it is not working for me. Or may be I am not getting this

please help me am a beginner of Magento

Answer 1

Go To :

1 - Login in to PhpMyadmin .

2 - Jump in to Magento's database .

3 - Go to admin_user table and edit the table .

4 - put a "password" (which you want) and select MD5 from function dropdown (Important).

This is working both in CE And EE latest version (tested in both latest version), no need of core file changes.

Answer 2

This would prove to be a good resource to read: http://www.magentocommerce.com/wiki/recover/resetting-admin-password

SELECT * FROM admin_user; 

Then, find the username you want to modify in the listing provided - ‘admin’ in this example. Then, to update the password, type:

UPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin'; 

‘qX’ would be changed to whatever you want it to be and same goes for ‘password’