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

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

did you (perhaps inadvertently) use the "favourites" filter ? press the star on top right of the tree and see if something happens...

thanks for your answer, but I have no filter.

Any other ideas?

Watch out for the yellow star button right besides the filters.

There is no filter.

Let's have a look on the screenshot

here

http://imgur.com/YP06jNT

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?

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,

Oh, great! Good finding!