0

SQL Commands like: show databases, show tables not working in MySQL Server 8

Hi, guys I have set up MySql Server 8 for my java project on Ubuntu 18.04 Possibly I am missing out something while upgrading from MySql server 5.7. Although I am using it any how but cannot issue some of the commands: show databases, show tables etc.

mysql> show databases;
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
mysql> show tables;
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

output:

ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
Vikram Thapa
  • 1
  • 1
    Possible duplicate of [MySQL error 1449: The user specified as a definer does not exist](https://stackoverflow.com/questions/10169960/mysql-error-1449-the-user-specified-as-a-definer-does-not-exist) – Sinto Dec 26 '18 at 04:04
  • something went wrong with your upgrade. Please post how you done it. – 2oppin Dec 26 '18 at 06:11

1 Answers1

1

The error has been fixed after this command:

sudo mysql_upgrade -u root -p
Slava SL
  • 11
  • 3