grant all privileges on dbname.* to username@‘userhost‘ identified by "userpassword"; flush privileges;
all privileges是所有权限，也可设置为分类，包含以下分类:select, insert, update, delete, create, drop,index, alter, grant, references, reload,shutdown, process, file
userhost不指定IP时可用%
执行完成之后不要忘记执行flush privileges;刷新权限
允许执行存储过程需要执行如下命令：
grant select on mysql.proc to username;
原文：https://www.cnblogs.com/happen-/p/10375055.html