I removed the main "admin" module permission for my admin user from Magento backend. After the changes were saved, the entire admin page now shows "access denied".
How can I fix this?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this communityI removed the main "admin" module permission for my admin user from Magento backend. After the changes were saved, the entire admin page now shows "access denied".
How can I fix this?
Atwix posted on their blog how to create an admin user
You can read from the query, how the ACL works and how to fix it on mysql level
SET @fistname = 'Fabian';
SET @lastname = 'Blechschmidt';
SET @email = 'mailaddress@example.com';
SET @username = 'fabian';
SET @password = 'password';
SET @salt = 'Fl';
INSERT INTO admin_user
SELECT
NULL user_id,
@fistname firstname,
@lastname lastname,
@email email,
@username username,
CONCAT(MD5(CONCAT(@salt, @password)), ':', @salt) password,
NOW( ) created,
NULL modified,
NULL logdate,
0 lognum,
0 reload_acl_flag,
1 is_active,
(SELECT MAX(extra) FROM admin_user WHERE extra IS NOT NULL) extra,
NULL rp_token,
NOW() rp_token_created_at;
INSERT INTO admin_role
SELECT
NULL role_id,
(SELECT role_id FROM admin_role WHERE role_name = 'Administrators') parent_id,
2 tree_level,
0 sort_order,
'U' role_type,
(SELECT user_id FROM admin_user WHERE username = @username) user_id,
@username role_name
If you use the command line tool magerun you can create a new admin user with full permissions with
n98-magerun.phar admin:user:create [username] [email] [password] [firstname] [lastname]