{"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

Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44,60,45],"tags":[],"aioseo_notices":[],"views":5,"_links":{"self":[{"href":"http:\/\/ndthanh.com\/wp-json\/wp\/v2\/posts\/303"}],"collection":[{"href":"http:\/\/ndthanh.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/ndthanh.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/ndthanh.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/ndthanh.com\/wp-json\/wp\/v2\/comments?post=303"}],"version-history":[{"count":0,"href":"http:\/\/ndthanh.com\/wp-json\/wp\/v2\/posts\/303\/revisions"}],"wp:attachment":[{"href":"http:\/\/ndthanh.com\/wp-json\/wp\/v2\/media?parent=303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/ndthanh.com\/wp-json\/wp\/v2\/categories?post=303"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/ndthanh.com\/wp-json\/wp\/v2\/tags?post=303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}