grant 权限 on 库.表 to 用户名@主机 identified by ‘密码‘ with grant option
mysql> grant all privileges on *.* to cj@localhost identified by ‘cj‘ with grant option;
刷新权限
flush privileges
删除用户
mysql> drop user cc@localhost;
查看用户权限
mysql> show grants for cj@localhost;
原文：http://www.cnblogs.com/powerCJ/p/5237748.html