Knowledgebase

Portal Home > Knowledgebase > Magento > How To Reset Magento Password


How To Reset Magento Password




It seems like the password must be typed and not copy/paste at least on the install part. good to know ;o)

The default login is : admin The default password is : 123123

If you are having troubles and want to reset it to a different password, just run at your sql database:

  1. 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:

  1. 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¢

You can also do this in phpMyAdmin, find the admin_user field and choose MD5 when updating password.

If you want to add a new admin user, you must not only create a new entry in the table ¡admin_user¢, but you also have to insert an entry in the table ¡admin_role¢ which has to be associated with the user by the field ¡user_id¢.



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
How to Change magento welcome E-mail Messages (Views: 331)
Optimise Magento - Increase Magento Speed (Views: 108)
CMS Page Gives 404 Error (Views: 55)
Remove the Coupon Code on the Magento Check Out Page (Views: 240)
How do I remove Help Us to Keep Magento Healthy - Report All Bugs (Views: 4804)