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

[expired user #8146]'s profile image [expired user #8146] posted 10 years ago in General Permalink
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's profile image jfalch posted 10 years ago Permalink
did you (perhaps inadvertently) use the "favourites" filter ? press the star on top right of the tree and see if something happens...
[expired user #8146]'s profile image [expired user #8146] posted 10 years ago Permalink
thanks for your answer, but I have no filter.

Any other ideas?
ansgar's profile image ansgar posted 10 years ago Permalink
Watch out for the yellow star button right besides the filters.
[expired user #8146]'s profile image [expired user #8146] posted 10 years ago Permalink
There is no filter.

Let's have a look on the screenshot
[expired user #8146]'s profile image [expired user #8146] posted 10 years ago Permalink
[expired user #8146]'s profile image [expired user #8146] posted 10 years ago Permalink


here

http://imgur.com/YP06jNT
ansgar's profile image ansgar posted 10 years ago Permalink
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?
[expired user #8146]'s profile image [expired user #8146] posted 10 years ago Permalink
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's profile image ansgar posted 10 years ago Permalink
Oh, great! Good finding!

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