I can reproduce this with MySQL 5.0 and 5.1 . See attached. Here user 'tttt' has insert privilege only to database 'test2'.
The icon is a table icon. But not placed in a database tree!! It stands alone!
And it does not not seem to be a graphical display error only , because when trying to
Code:
alter table test2.item add column peter bigint;
mysql returns
Quote:
ALTER command denied to user 'tttt'@'localhost' for table 'item'
Trying on table test
Code:
alter table test.item add column peter bigint;
returns
Quote:
Table 'test.item' doesn't exist
.
However opening another connection as root does not find any test2.item or just item DB. 5. Also the database test2 does not show up at all when a similar setup is crated with MySQL version 4.0 or 4.1 (unless it is InnoDB!)
It is a harmless phenomenon, I believe, but never the less some kind of small bug with SQLyog in relation to MySQL 5.x – or a small bug just only visible in MySQL 5.
Pics:
Left: phenomenon displayed in MySQL 5.
Mid: MySQL 4 – nothing is dispalyed as user has no select privilege at all.
Right: MySQL 3.23 displays this err mess when trying to open table tree.
The different behaviour(s) of 3.23 and 4.0 is a know issue with the respective MySQL version and tables with no SELECT-privilege..
However wasn't MySQL 5 expected to behave like 4.x ?