Skip to content

Instantly share code, notes, and snippets.

@KaySchneider
Created October 18, 2017 13:25
Show Gist options
  • Save KaySchneider/3eb60bf3ff28b40f2496c74c60398000 to your computer and use it in GitHub Desktop.
Save KaySchneider/3eb60bf3ff28b40f2496c74c60398000 to your computer and use it in GitHub Desktop.
add a new magento admin user with mysql ;-)
LOCK TABLES `admin_role` WRITE , `admin_user` WRITE;
SET @SALT = "yourInstallationSalt";
SET @PASS = CONCAT(MD5(CONCAT( @SALT , "YOURPASSWORDSTRING") ), 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 ('firstName','lastName','maik@example.com','username',@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 = 'yourUserName'),'yourUserName');
UNLOCK TABLES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment