MySQL 授权(grant[GRANT])与 撤销授权(revoke[REVOKE])

grant 用法：grant 权限 on 数据库 to 用户！

1 增删改查 普通基础用户的权限：

比如：

grant select on databasename.* to common_user@%;grant delete on databasename.* to common_user@%;grant update on databasename.* to common_user@%;grant insert on databasename.* to common_user@%;

联合到一起！

grant select,delete,update,insert on databasename.* to common_user@%;