Hi :-)

Would it be possible to include a global setting in sqlyog whether to show the information_schema database or not. Of course not all servers/instances would expose this, but it would be good to have a final control whetger to include this in the db/table browsing list on the left.

I am aware that some would dislike this kind of hiding, so default setting should be to list it if possible.

I'm also only about 99% sure there is no such setting already. At least i never saw it

(Free version. If it is included in pay version i really like to see this in all versions! )

-Per

In the connections manager you may specify the databases you want to have visible.


As per (MySQL server) design every user has select privilege to access I_S. All servers that have an I_S (5.0+) will expose it! Basically we do not think we on the 'client side' should try to change 'server functionalities'. Even if we hide it, user can still execute for instance





Why do you want to change that? Some security consideration that not every user should be able read the contents? This is not required because only the content that a user has privilege to will be displayed (try create a user with no privileges and he can see the I_S and the tables of the I_S, but not the contents of I_S.tables and I_S.routines etc ...(I_S tables display empty for such user). And user may just connect from another client ...

Or is it only a cosmetcial thing that it does not 'look nice'?

Hi :-)

Actually i see it as both a cosmetical and security improvement if it can be hidden. In all my years with (my)sql-coding i still have not had to deal with this table. Maybe that means im not an advanced user then??

IMHO the 3 most essential "power features" of MySQL (or any DB for that matter) are:

- foreign keys
- triggers
- stored procedures

I never found views essential for my needs.

Kind regards,

Per

PS! Actually the connections manager would be a good place to specify to exclude viewing these system tables.