On MySQL8.0 'show databases;' command gives " ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist"

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content