ERROR 1449 (HY000): The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist

2

After lots of attempt，the solution is delete user mysql.infoschema first and then do vamshi’s steps:

Create user:

mysql> CREATE USER ‘mysql.infoschema’@‘localhost’ IDENTIFIED BY ‘password’;
Query OK, 0 rows affected (0.00 sec)
Grant permissions:

mysql> GRANT SELECT ON . TO mysql.infoschema@localhost;
Query OK, 0 rows affected, 1 warning (0.00 sec)
Share
Follow
edited Jan 5 at 11:30

Jan Sršeň
1,01633 gold badges1717 silver badges3737 bronze badges
answered Jan 5 at 7:42

xiaoer wang
2111 bronze badge
Add a comment

2

Delete the problematic user
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;