TiDB建库建用户及授权

TiDB建库授权

先把密码长度改短

set global validate_password_length=3;

给root授权远程访问

ALTER USER 'root'@'%' IDENTIFIED BY 'Umta&152';
grant all privileges on *.* to 'root'@'%' identified by 'Umta&152';

svc添加svc用户和相关权限

#建
CREATE USER 'svc'@'localhost'  IDENTIFIED BY 'Abc*231';
#建
CREATE USER 'svc'@'%'  IDENTIFIED BY 'Abc*231';

授权

grant all privileges on svc.* to 'svc'@'localhost' identified by 'Abc*231';
grant all privileges on svc.* to 'svc'@'%' identified by 'Abc*231';