Mysql 用户授权与回收

1. 授予表和列权限

权限：select , insert ,delete ,update , references ,create, alter ,index, drop , all 或 all privileges.

例： grant select on table_1 to user1;

grant update(name,age) on table_userinfo to Jim;//授予对列的更新权限。

 

2.授予数据库权限：

权限：select , insert , delete ,update ,references ,create ,alter ,drop , index, create temporary tables, create view , show view , create routine ,alter routine ,execute routine,

lock tables , all 或 all privileges .

例： grant select on testbase.* to Jim;

3.权限回收：

revoke select on table_1 from Jim;

revoke select on testbase from Jim;