Why isn't INFORMATION_SCHEMA not displayed in the MySQL Workbench UI by default?

Why isn't INFORMATION_SCHEMA not displayed in the MySQL Workbench UI by default?

回答1

Click on

Edit -> Preferences -> SQL Editor and then check the box "Show Metadata and Internal Schemas"

Click on Refresh icon on the right side of Schemas in the left side bar.

I am using 6.3CE. Older versions may have something similar.

 

MySQL Workbench, Windows Server 2019, MySQL not showing Performance, Information of MySQL Schemas! - Database Administrators Stack Exchange

A similar issue, Information_Schema and mysql databases not shown, was submitted as a bug report to the MySQL Bug System nine years ago. The report was resolved as Not a Bug as the issue turned out to be something controlled by one of MySQL Workbench settings. Specifically, Valeriy Kravchuk suggested this resolution:

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.

 

作者:Chuck Lu    GitHub