【024】修改EA密码

永久修改EA密码

-- 设置密码123456:
update Base_User set Password=upper(substring(sys.fn_VarBinToHexStr(hashbytes('MD5', CAST('zgv9FQWbaNZ2iIhNej0+jA==' as varchar(50)) + convert(char(36),base_user.salt))),3,32)) 
where Code = 'EA'

临时修改EA密码

-- 先保存一下原来的EA密码
declare @Pwd nvarchar(50)
select @Pwd=Password from Base_User where Code = 'EA'
select @Pwd

-- 设置密码123456:
update Base_User set Password=upper(substring(sys.fn_VarBinToHexStr(hashbytes('MD5', CAST('zgv9FQWbaNZ2iIhNej0+jA==' as varchar(50)) + convert(char(36),base_user.salt))),3,32)) 
where Code = 'EA'

-- 用完之后还原
update Base_User set Password= @Pwd where Code = 'EA'

启用用户

-- 启用用户
update Base_User set IsAlive=1 where code='adminwc'

修改密码为空

UPDATE Base_User SET
Password = UPPER(SUBSTRING(sys.fn_VarBinToHexStr(HASHBYTES('MD5', CAST('1B2M2Y8AsgTpgAmY7PhCfg==' AS VARCHAR(50)) + CONVERT(CHAR(36), base_user.salt))), 3, 32))
WHERE Code = 'admin';

如果是比较旧的U9版本

一般执行上面的语句会报salt字段不存在

update Base_User set Password='1B2M2Y8AsgTpgAmY7PhCfg==' where Code='admin'