0
I set up a MySQL Server on a Ubuntu machine.
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.
Herry
Posted 2019-08-11T18:19:46.977
Reputation: 1