MySQL Workbench - Tables could not be fetched

Uit De Vliegende Brigade
Ga naar: navigatie, zoeken

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