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
3 months 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
3 months ago
412 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
3 months ago
6 posts since Wed, 18 Jun 14
thanks for your answer, but I have no filter.

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

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


here

http://imgur.com/YP06jNT
Written by ansgar
3 months ago
5045 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
3 months 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
3 months ago
5045 posts since Fri, 07 Apr 06
Oh, great! Good finding!
 

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