CODEWITHSUNDEEP
magento
Sankar Subburaj
Sankar Subburaj

Reputation: 5042

Manage admin account in magento

I developed a site in Magento Professional edition few month back. After a long time I login in admin, magento through an error that admin password was expired. In how many days the admin account will expire and could we manage it.

Upvotes: 1

Views: 2676

Answers (3)

Kalpesh
Kalpesh

Reputation: 5685

@SteveRobbins's query is good when it requires to re-activate all the admin users.

For re-activating just 1 admin user run this query:

UPDATE enterprise_admin_passwords SET expires = UNIX_TIMESTAMP() + (365 * 24 * 60 * 60) WHERE user_id in (select user_id from admin_user where username='YOUR_ADMIN_USERNAME')

Or just remove all the entries for that user in enterprise_admin_passwords table:

delete from enterprise_admin_passwords where user_id in (select user_id from admin_user where username='YOUR_ADMIN_USERNAME');

Upvotes: 0

Steve Robbins
Steve Robbins

Reputation: 13802

UPDATE enterprise_admin_passwords
SET expires = UNIX_TIMESTAMP() + (365 * 24 * 60 * 60)

Will give each admin another year.

Clear your cookies and try again.

Upvotes: 2

Dmytro Zavalkin
Dmytro Zavalkin

Reputation: 5277

Go to System->Configuration, ADVANCED->Admin->Security and see Password Lifetime (days) and Password Change fields.

Upvotes: 5

Related Questions