MySQL Workbench - Tables could not be fetched
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.
The cause of the problem: A faulty view that referred to a column that no longer existed.
- 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.