pragyapradhan
8/15/2017 - 5:53 AM

create new Magento admin user from db, with Magento hash(password) Run this code in phpmyadmin/ sql/ or sql console use db that you wan

create new Magento admin user from db, with Magento hash(password)

Run this code in phpmyadmin/ sql/ or sql console use db that you want to change password for

admin_user.sql
content_copyfile_download
LOCK TABLES `authorization_role` WRITE , `admin_user` WRITE;
 
SET @PASS = '4473dbb95606b3b0a84b832d960925e62cd4aa19fdbd73be65351c503e5aa4bc:FtqVETn4JddM8CjgXJqaWqZx5qUWs2dx:1';
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','email4@example.com','prapradhan',@PASS,NOW(),0,0,1,@EXTRA,NOW());

INSERT INTO `authorization_role` (parent_id,tree_level,sort_order,role_type,user_id,user_type,role_name) 
VALUES (1,2,0,'U',(SELECT user_id FROM admin_user WHERE username = 'prapradhan'),2,'Firstname');

UNLOCK TABLES;