误删MySQL mysql.infoschema 用户。The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does no
1. 控制台连接MySQL
mysql -uroot -proot
2. 创建用户
CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'password';
3. 赋权
GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`;
4. 完工。
原创
2020-11-16 18:53:31 ·
1012 阅读 ·
3 评论