DROP USER 'mysql.infoschema'@'localhost';
The rest of the solution is like previous answers.
- Create the user again
- Grant it permissions
-
mysql> CREATE USER 'mysql.infoschema'@'localhost' IDENTIFIED BY 'password'; mysql> GRANT SELECT ON *.* TO `mysql.infoschema`@`localhost`;