mysql常用操作语句

授权语句

grant all privileges on <dbname>.* to <username>@'%' identified by <password> with grant option;
flush privileges;

with grant option表示该用户可以将自己拥有的权限授权给别人。