grant select on *.* to za@localhost;
revoke select on *.* to za@localhost;
grant all privileges on *.* to z1@localhost;
grant all privileges *.* to z1@localhost with grant option;
grant all privileges *.* to z1@localhost identified by ‘123456‘ with grant option;
grant select ,insert ,update,delete on test1.* to ‘用户名‘@‘密码‘ identified by ‘123‘;
grant super,process,file on *.* to ‘用户名‘@‘密码‘;（因为这几个权限都属于管理权限，因此不能够指定了某个数据库，on后面必须跟*.*）
show grants for ‘用户名‘@‘密码‘;
原文：http://www.cnblogs.com/lehao/p/3926562.html