TIDB创建用户并授权

创建

create user test identified by '123456';

修改密码

alter user test identified by '123789';

创建库

create database test1 char set utf8;

授权

grant all privileges on test1.* to test identified by 'tyui67890';

取消授权

revoke all on test1.* from 'test';

查看授权

show grants for 'test';