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';
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/100367.html原文链接:https://javaforall.net