mysql-ERROR 1449

mysql 8.0.28版本、linux下

1449 - The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

解决

-- 创建'root'@'%'账户

 CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'root';

-- 给'root'@'%'账户设置权限

 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

-- 刷新权限

 flush privileges;

create user 'mysql.infoschema'@'localhost';

grant all privileges on *.* to 'mysql.infoschema'@localhost;

grant grant option on *.* to 'mysql.infoschema'@'localhost';