mysql 用户权限

一，创建一个没有任何权限的常规用户：

mysql > grant usage

         - > on books.*

         - > to sally identified by 'magic123';

二，授予适当权限：

mysql > grant select ,insert,update,delete,index,alter,create,drop

         - > on books.*

         - > from sally;

三，减少一些权限：

mysql > revoke alter,create,drop

         - > on books.*

         - > from sally;

四，撤销所有权限：

mysql > revike all

         - > on books.*

         - > from sally;