CODEWITHSUNDEEP
mysqlmysql-8.0
Vikram Thapa
Vikram Thapa

Reputation: 1

ERROR 1449 (HY000): problem encountered while issuing commands like 'show databases', 'show tables' etc. in MySQL 8

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

Upvotes: 0

Views: 551

Answers (1)

Slava SL
Slava SL

Reputation: 11

The error has been fixed after this command:

sudo mysql_upgrade -u root -p

Upvotes: 1

Related Questions