Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LOCK TABLES `admin_role` WRITE , `admin_user` WRITE;
- SET @SALT = "salt"; -- take it from: app/etc/local.xml -> config/global/crypt/key
- SET @PASSWORD = "password";
- SET @PASS = CONCAT(MD5(CONCAT( @SALT , @PASSWORD) ), CONCAT(":", @SALT ));
- SET @FIRSTNAME = "Admin";
- SET @LASTNAME = "Admin";
- SET @EMAIL = "admin@example.com";
- SET @USERNAME = "admin";
- 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,@EMAIL,@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 = @USERNAME),@FIRSTNAME);
- UNLOCK TABLES;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement