MySQL Forums
Forum List  »  MySQL Workbench

Error loading schema content
Posted by: Luke Brooks-Shesler
Date: May 30, 2019 05:45AM

I'm running MySQL Workbench 8.0.16 on macOS High Sierra version 10.13.6.

When I open a connection, beneath the sys schema, it says that Tables, Views, Stored Procedures, and Functions could not be fetched.

In the Action Output section, I receive an error message:

Beneath "Action": Error loading schema content
Beneath "Response": Error Code: 1356 View 'sys.innodb_lock_waits' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them.

However, when I expand beneath "Tables could not be fetched", a new table that I created appears and I can view and edit the table.

I'm not sure why I keep getting the same error message, but I would be grateful to anyone who might have a suggestions about how to resolve this issue. Thank you!

Options: ReplyQuote


Subject
Views
Written By
Posted
Error loading schema content
2130
May 30, 2019 05:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.