How do I reset Magento Admin User Role

Pinterest LinkedIn Tumblr

I try to remove All Administrators’s Rule. then I done Below thing to get All Admin user’s Role.

Note:- use mysqldump to back up your databases before doing anything further

Table :-  authorization_rule

Step-2: truncate Table using truncate command

truncate authorization_rule

Step 3) This insert Data into authorization_rule

INSERT INTO authorization_rule (rule_id, role_id, resource_id, privileges, permission) VALUES (1, 1, 'Magento_Backend::all', NULL, 'allow');

Step-4: Run below Magento Command

php bin/magetno set:up;

php bin/magetno s:s:d -f ;

php bin/magetno c:f ;

php bin/magetno c:c ;

Write A Comment