{"id":303,"date":"2013-01-18T08:02:11","date_gmt":"2013-01-18T08:02:11","guid":{"rendered":"http:\/\/invisiblezero.net\/?p=303"},"modified":"2013-01-18T08:02:11","modified_gmt":"2013-01-18T08:02:11","slug":"resetting-magento-admin-password","status":"publish","type":"post","link":"http:\/\/ndthanh.com\/resetting-magento-admin-password\/","title":{"rendered":"Resetting Magento Admin Password"},"content":{"rendered":"
It seems like the password must be typed and not copy\/paste at least on the install part. good to know ;o)<\/p>\n
The default login is : admin The default password is : 123123<\/p>\n
If you are having troubles and want to reset it to a different password, just run at your sql database:<\/p>\n
\nSELECT * FROM admin_user;\n\n<\/pre>\n
\nThen, find the username you want to modify in the listing provided – \u2018admin\u2019 in this example. Then, to update the password, type:<\/p>\n\nUPDATE admin_user SET password=CONCAT(MD5('qXpassword'), ':qX') WHERE username='admin';\n\n<\/pre>\n\u2018qX\u2019 would be changed to whatever you want it to be and same goes for \u2018password\u2019<\/p>\n
You can also do this in phpMyAdmin, find the admin_user field and choose MD5 when updating password.<\/p>\n
If you want to add a new admin user, you must not only create a new entry in the table \u2018admin_user\u2019, but you also have to insert an entry in the table \u2018admin_role\u2019 which has to be associated with the user by the field \u2018user_id\u2019.<\/p>\n","protected":false},"excerpt":{"rendered":"
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: SELECT *…<\/p>\n