fiblog

创建用户：
grant usage on books.* to sally identified by 'magic123';
创建一个没有任何权限的密码为magic123的用户sally,将usage换成all，就是赋予所有权限

赋予权限：
grant  select,insert,update,delete,index,alter,create,drop on books.* to sally;
上面两句，可以合成:

grant select,insert,update,delete,index,alter,create,drop on books.* to sally identified by 'magic123';

减少权力:

revoke alter,create,drop on books.* from sally;

撤销所有权限:

revoke all on books.* from sally;