mysql意外删除用户后解决

Mysql Error:The user specified as a definer (‘mysql.infoschema’@’localhost’) does not exist 错误提示
因为 账户被意外删除了，所以重新创建一个
登录后 创建
use mysql;
create user ‘mysql.infoschema’@‘localhost’ identified by ‘密码’;
添加权限
update user set Select_priv = ‘Y’ where User = ‘mysql.infoschema’;
保存
flush privileges;

退出
eixt
收工