錯誤場景
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
查詢是否有這個賬戶
select user,host from mysql.user where user='mysql.infoschema';
查看這個賬戶的權(quán)限
show grants for 'mysql.infoschema'@'localhost';
刪除這個mysql.infoschema
DROP USER 'mysql.infoschema'@'localhost';
創(chuàng)建mysql.infoschema
CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'password';
授權(quán)
GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`;
