pragyapradhan
6/30/2017 - 4:18 AM

MySQL - Creating new user and password

MySQL - Creating new user and password

MySQL -Creating new users
content_copyfile_download
LOCK TABLES `authorization_role` WRITE , `admin_user` WRITE;
 
SET @PASS = '82bfe44ef5f2495e85326b027a3ee4280e212cd2db2bd368f0d4739c937f0082:Weg2ZoashusiBv6Dmb0h20T7XLNY26NK: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','myuser3',@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 = 'myuser3'),2,'Firstname');
UNLOCK TABLES;