mysql-workbenchworkbenchkie-workbenchsql-workbench-j

Reputation: 321

Tables could not be fetched - Error loading schema content

I open workbench and connect to a local database on XAMPP and when open the connection the schema show the error message:

"tables could not be fetched"

Upvotes: 25

Answers (14)

Usman Mutawakil

Reputation: 5259

Alternate cause for same error (invalid/broken SQL in views)

There is an alternate cause for this error that has nothing to do with compatibility issues, not to mention mysql_upgrade is deprecated now. If you have altered table names and/or column names so that some of your views are now broken then you can get this error after MySQL is restarted. Fixing whats wrong in your views can solve the problem (deleting the views works if you're able to do that but obviously thats not possible in every use case...)

Upvotes: 1

komal

Reputation: 1

If you have create view table earlier and than renamed the table or any columns than you also have to change the name manually in view

Upvotes: 0

RobyRew

Reputation: 111

As @Brittany Layne Rapheal says, with that command you can fix the issue, is also recommended to give execution privileges to that file:

So you should run first this command:

sudo chmod +x /Applications/XAMPP/xamppfiles/bin/mysql_upgrade

And then, this:

sudo /Applications/XAMPP/xamppfiles/bin/mysql_upgrade --force

--force is necessary because as the parameter says to force the update (Necessary)

Upvotes: 1

Anh Tuấn Lê

Reputation: 199

Run this command on terminal

sudo /opt/lampp/bin/mysql_upgrade

And as per the comment by @jonathan-delean , you might need to run this instead:

sudo /opt/lampp/bin/mysql_upgrade -u root -p

Upvotes: 17

Chi Lin

Reputation: 1

this works for me

sudo mysql_upgrade --force

Upvotes: 0

constant283

Reputation: 61

See YouTube video: MySQL 8 - The message "Tables Could Not Be Fetched" https://www.youtube.com/watch?v=phi6o8B7kKI

Either a table or view or function used in code has been dropped; hence the "...could not be fetched".

Upvotes: 0

maddgerald

Reputation: 41

for macOS users run this on terminal: sudo /Applications/XAMPP/bin/mysql_upgrade this worked for me

Upvotes: 4

Luuk

Reputation: 14930

I did have this problem today, the reason is:

Error Code: 1356 View 'test.xyz' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

After dropping those view (actually those views) the error was solved.

currently working with MySQL Workbench 8.0.28, and MySQL 8.0.28.

Upvotes: 1

PSS

Reputation: 39

I created another Connection in MySQL workbench, and the fetching problem for me was resloved.

Upvotes: 0

Brittany Layne Rapheal

Reputation: 752

For XAMPP, this worked for me - run this on terminal:

sudo /Applications/XAMPP/xamppfiles/bin/mysql_upgrade

Disconnect then reconnect to your db.

Upvotes: 18

Aleti

Reputation: 75

For MacOS users:

sudo /Applications/XAMPP/bin/mysql_upgrade

Upvotes: 0

Alduin The Khajiiti Nord

Reputation: 31

First, locate the directory of which Xampp is installed at. In linux you can just type this in a terminal:

whereis xampp

In my case (btw I use arch, jk) it was located at /opt/lampp/bin . If you're using windows, you may find it under a different location, like in C:\Program Files\xampp\bin

Next, locate the file mysql_upgrade and execute it as an administrator or a sudo. If you're using Linux: cd /opt/lampp/bin then sudo ./mysql_upgrade

According to MySQL documentation:

Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that might have been added. It upgrades the Performance Schema, INFORMATION_SCHEMA, and sys schema. It examines user schemas.

So I believe mysql_upgrade should resolve the problem. It worked for me before.

Tables could not be fetched - Error loading schema content

Answers (14)

Related Questions