distal-attribute
distal-attribute
distal-attribute
distal-attribute

I can't see tables on the tree (I can see functions and procedures) - Mysql 5.5

nicolasTT posted 4 months ago in General
Hi,

I'd like to display tables on the tree. I don't know why the tables are not displayed.
There is no filter on table, and I can see the functions...

When I use another database, there is no problem : I can see the tables in the tree.
And it's not a problem of rights. I can make request, and I can see the tables with workbench.

Any ideas?

Thanks,

Nicolas
jfalch posted 4 months ago
did you (perhaps inadvertently) use the "favourites" filter ? press the star on top right of the tree and see if something happens...
nicolasTT posted 4 months ago
thanks for your answer, but I have no filter.

Any other ideas?
ansgar posted 4 months ago
Watch out for the yellow star button right besides the filters.
nicolasTT posted 4 months ago
There is no filter.

Let's have a look on the screenshot
nicolasTT posted 4 months ago
nicolasTT posted 4 months ago


here

http://imgur.com/YP06jNT
ansgar posted 4 months ago
Ok, then we should watch out for the result of SHOW TABLE STATUS on your "empty" database. Could you post basic results here, at least the number of tables returned by that query?
nicolasTT posted 4 months ago
Thanks for your idea of 'SHOW TABLE STATUS'.

We have solved the issue.
It was caused by a view which needs a user who didn't exist in this database.
We find the solution with the error 1143 of
SHOW TABLE STATUS;
/* SQL Error (1143): SELECT command denied to user 'appli'@'%' for column 'XXXXX' in table 'YYYYYY' */
and
http://stackoverflow.com/a/6656302

Thanks,
ansgar posted 4 months ago
Oh, great! Good finding!

Please login to leave a reply, or register at first.