MySQL Bugs: #64397: mysql workbench schema side bar does not list all databases

Bug #64397	mysql workbench schema side bar does not list all databases
Submitted:	21 Feb 2012 11:02	Modified:	21 Feb 2012 11:24
Reporter:	Shiva Sanyasi	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.37	OS:	Linux (Ubuntu 11.10)
Assigned to:		CPU Architecture:	Any
Tags:	MySQL, schema, workbench

Description:
The schema sidebar does not list 'mysql' db and 'information_schema' db. Other user created databases are listed fine. The 2 databases are listed in phpmyadmin, when connected to same server using same user and password from same host. So, I believe it is not related to user/host/privileges. Please advise.

How to repeat:
Open mysql workbench
Connect to remote database (connection test successful)
Open SQL Editor
SCHEMAS sidebar is empty if no user db created and shows only the user created db if there are user created databases. 'mysql' and 'information_schema' are not listed here. But the databases and their tables are accessible via queries.

Suggested fix:
List all databases in SCHEMAS side bar

Please, check the Preferences > SQL Editor > Show Metadata Schemata checkbox. Try again after that.

That was it! Apologies for mistaking preference for bug!

Thanks for help.

Why this setting is not by default?

I definately agree on this one!! I am a beginner and it is taking me hours to just find the schema I just created. it is more of a bug looking feature.