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

User, date Message
Written by nicolasTT
1 month ago
Category: General
6 posts since Wed, 18 Jun 14
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
Written by jfalchMoney, Euro
1 month ago
380 posts since Sat, 17 Oct 09
did you (perhaps inadvertently) use the "favourites" filter ? press the star on top right of the tree and see if something happens...
Written by nicolasTT
1 month ago
6 posts since Wed, 18 Jun 14
thanks for your answer, but I have no filter.

Any other ideas?
Written by ansgar
1 month ago
4936 posts since Fri, 07 Apr 06
Watch out for the yellow star button right besides the filters.
Written by nicolasTT
1 month ago
6 posts since Wed, 18 Jun 14
There is no filter.

Let's have a look on the screenshot
Written by nicolasTT
1 month ago
6 posts since Wed, 18 Jun 14
Written by nicolasTT
1 month ago
6 posts since Wed, 18 Jun 14


here

http://imgur.com/YP06jNT
Written by ansgar
1 month ago
4936 posts since Fri, 07 Apr 06
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?
Written by nicolasTT
1 month ago
6 posts since Wed, 18 Jun 14
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,
Written by ansgar
1 month ago
4936 posts since Fri, 07 Apr 06
Oh, great! Good finding!
 

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