MySQL Workbench - Tables could not be fetched

Problem

On one beautiful afternoon in Januari 2021, MySQL Worbench greeted me with these worrying messages, when I opened my oh so precious database:

Tables could not be fetched
Views could not be fetched
Stored procedures could not be fetched
Functions could not be fetched

Some sources suggested running mysql_upgrade, but that routine really doesn't seem to exist anymore.

Cause

The cause of the problem: A faulty view that referred to a column that no longer existed.

Solution

• Copy the content of the view to a text editor
• Delete the view
• Restart MySQL Workbench
• Recreate the view.

Just correcting the view didn't seem to be working: After waiting for a little while, I killed MySQL Workbench.

Sources

• https://stackoverflow.com/questions/59298940/mysql-workbench-shows-tables-stored-procedures-views-could-not-be-fetched-in