参考:https://www.cnblogs.com/fslnet/p/3143344.html
创建用户
create user ytl IDENTIFIED by ‘pwd’;
查看权限
show grants for ytl;
授予权限
grant select on database.table to ytl;
mysql 用户管理和权限设置
最新推荐文章于 2024-09-04 20:48:11 发布
参考:https://www.cnblogs.com/fslnet/p/3143344.html
创建用户
create user ytl IDENTIFIED by ‘pwd’;
查看权限
show grants for ytl;
授予权限
grant select on database.table to ytl;