No Administrators role was found, data fixture needs to be run

 Error Details

In AdminAccount.php line 262:

  No Administrators role was found, data fixture needs to be run

admin:user:create [--admin-user ADMIN-USER] [--admin-password ADMIN-PASSWORD] [--admin-email ADMIN-EMAIL] [--admin-firstname ADMIN-FIRSTNAME] [--admin-lastname ADMIN-LASTNAME] [--magento-init-params MAGENTO-INIT-PARAMS]

Solution

> INSERT 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');

References

https://blog.chapagain.com.np/magento-2-no-administrators-role-was-found-data-fixture-needs-to-be-run-while-creating-admin-user-from-command-line/