mysql为其他用户刷新权限

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