Adding Magento Admin Users

Posted 18th Desember, 2018

If you do not have access to the Magento admin area, Magento admin users can be added via the database. Use the following script, replacing every work prefixed with x

`code LOCK TABLES admin_role WRITE , admin_user WRITE;

SET @SALT = "rp"; SET @PASS = CONCAT(MD5(CONCAT( @SALT , "xpassword") ), CONCAT(":", @SALT )); SELECT @EXTRA := MAX(extra) FROM admin_user WHERE extra IS NOT NULL;

INSERT INTO admin_user (firstname,lastname,email,username,password,created,lognum,reload_acl_flag,is_active,extra,rp_token_created_at) VALUES ('xFirstname','xLastname','[email protected]','xmyuser',@PASS,NOW(),0,0,1,@EXTRA,NOW());

INSERT INTO admin_role (parent_id,tree_level,sort_order,role_type,user_id,role_name) VALUES (1,2,0,'U',(SELECT user_id FROM admin_user WHERE username = 'xmyuser'),'xFirstname');

UNLOCK TABLES; `