Bug #53154 Information_Schema and mysql databases not shown
Submitted: 26 Apr 2010 10:02 Modified: 26 Apr 2010 10:38
Reporter: Juan Carlos Farina Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.19 OS:Windows (XP Pro)
Assigned to: CPU Architecture:Any

[26 Apr 2010 10:02] Juan Carlos Farina
After connecting to a Server using 'SERVER ADMINISTRATION' option of MySQL Workbench, I can not see the information_schema and mysql databases. If connect to the same server with MySQL Administrator, this databases are shown when I click on the Catalogs option in the upper left pane. Could you please help me on this?

Many thanks in advanced,

Juan C. Farina
Database Department
Securitas Direct

How to repeat:

Conecting to any MySQL server.
[26 Apr 2010 10:07] Juan Carlos Farina
Screen capture of MySQL Workbench and MySQL Administrator

Attachment: MySQL Workbench Bug.pdf (application/pdf, text), 53.96 KiB.

[26 Apr 2010 10:38] Valeriy Kravchuk
Please, check "Show Metadata Schemata" checkbox in the Query Editor group of the SQL Editor tab in the Workbench Preferences dialog box. Use Edit > Preferences... menu item to open it. Don't forget to click "Refresh all" in the Object Browser's context menu after that.
[2 Nov 2010 18:28] Marco Glez
Thanks to Valeriy for the help, it works!!