(I took this unanswered question from the internet beacuase it explained my situation very good and I am also using a mac)
I added a user A with only access to one Database 'B'.
If I log in with it in MySQL Workbench, it shows me:
Tables could not be fetched
Views could not be fetched
Stored procedures could not be fetched
Functionscould not be fetched
The fun thing is that under "Tables could not be fetched" all tables of the DB are shown. The query SHOW TABLES; also gives the correct result.
If I log in with the root user or a user with all privileges on . it displays everything correctly.
I have tried the solution mysql mysql_upgrade -u root -p --force and mysql_upgrade -u root -p but i got the errror below.