Advertisement
Guest User

Untitled

a guest
Dec 10th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. LOCK TABLES `admin_role` WRITE , `admin_user` WRITE;
  2.  
  3. SET @SALT = "rp";
  4. SET @PASS = CONCAT(MD5( CONCAT(@SALT, "super_secure_password") ), CONCAT(":", @SALT));
  5. SELECT @EXTRA := MAX(extra) FROM admin_user WHERE extra IS NOT NULL;
  6.  
  7. INSERT INTO `admin_user` (firstname, lastname, email, username, password, created, lognum, reload_acl_flag, is_active, extra, rp_token_created_at)
  8. VALUES ('FirstName', 'LastName', 'email@yourdomain.com', 'your_username', @PASS,NOW(), 0, 0, 1, @EXTRA,NOW());
  9.  
  10. INSERT INTO `admin_role` (parent_id, tree_level, sort_order, role_type, user_id, role_name)
  11. VALUES (1, 2, 0, 'U', (SELECT user_id FROM admin_user WHERE username = 'your_username'), 'FirstName');
  12.  
  13. UNLOCK TABLES;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement