If you have managed to loose your role permissions, like this: How do I reset Magento Admin User Role

  • I deleted the error, the admin role in Magento2 and can not log in. How do I restore?
    – Cri
    Mar 20, 2019 at 17:49
  • This is not an answer to the question. Please provide an answer or consider asking a new question.
    – HelgeB
    Mar 20, 2019 at 18:09
  • If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review Mar 20, 2019 at 19:03

1 Answer 1


Note:- Use mysqldump to back up your database before doing anything further, As it will change the database values and will not be recoverable.

Run this sql command to reset role with id 1 to all permissions:

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

Run this if you have deleted the Administrator group:

REPLACE INTO authorization_role 
    (`role_id`, `parent_id`, `tree_level`, `sort_order`, `role_type`, `user_id`, `user_type`, `role_name`)
VALUES (1, 0, 1, 1, 'G', 0, '2', 'Administrators')

Note the use of REPLACE, this will delete any existing. So be mindful of that.

Lastly you need to make sure your user have the correct role:

REPLACE INTO authorization_role 
    (`role_id`, `parent_id`, `tree_level`, `sort_order`, `role_type`, `user_id`, `user_type`, `role_name`)
    (2, 1, 2, 0, 'U', <insert your user id here>, '2', <insert user name here>)

You can find your user id by running:

SELECT `user_id`, `username` FROM `admin_user`;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.