How to Reset Magento Admin User, Role and Resources Permission to all

In this blog you will learn how to Reset Magento Admin User, Role and Resources Permission to all.

Suppose, by mistake you have to define wrong permission of main admin User and you can not reset all permission in main admin user.



You define wrong permission of main admin .



Set wrong permission and you can not reset in main admin user .



Solution

Open database follow the step:

Step 1: Get current admin role details.

SELECT * FROM admin_role WHERE role_name = 'Administrators'
/*Administrators - is Your admin role name*/

Step 2: Remove Existing permissions for the Admin role:

/*clean all permission rules*/
DELETE admin_rule
FROM admin_rule, admin_role
WHERE
admin_role.role_name = 'Administrators' /* Your admin role name*/
AND admin_rule.role_id = admin_role.role_id

Click go button.

Step 3: Update Permission rule for the admin role.



Click go button.



Log out & try to login with your credentials to logged in.

So you can reset all permission to the main admin user.