TiDB建库建用户及授权

set global validate_password_length=3;

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

#建
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';