MySQL 赋予用户权限命令的简单格式可概括为:
1:grant 权限 on 数据库对象 to 用户
例:grant select on test.* to common_user@'%'
grant select, insert, update, delete on test.orders to dba@localhost;
2:查看当前用户(自己)权限:
show grants;
1:grant 权限 on 数据库对象 to 用户
例:grant select on test.* to common_user@'%'
grant select, insert, update, delete on test.orders to dba@localhost;
2:查看当前用户(自己)权限:
show grants;