On MySQL8.0 'show databases;' command gives " ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist"
Issue
- After the Export/Import the database on MySQL5.7 running RHEL6.10 into MySQL8.0 on RHEL8.3, the "show databases" command starts to end up showing below error.
mysql> show databases;
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
Environment
- Red Hat Enterprise Linux 6
- Red Hat Enterprise Linux 8
- MySQL-MySQL5.7
- MySQL-MySQL8.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.