【无标题】

mysql 1449错误

1449 (HY000): The user specified as a definer (‘mysql.infoschema’@‘localhost’) does not exist
解决方法1:
给root用户授权
grant all privileges on . to ‘root’@‘%’ identified by “root”;
或grant all privileges on . to ‘root’@‘%’;
或GRANT ALL PRIVILEGES ON . TO ‘root’@'%'WITH GRANT OPTION;
解决方法2
他说没有这个用户但是有就删了重建
drop user mysql.infoschema@“localhost”;
create user mysql.infoschema@“localhost” identified by ‘root’;
flush privileges;
use mysql;
update user set Select_priv = ‘Y’ where User = ‘mysql.infoschema’;