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.

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.