MySQL Workbench, Windows Server 2019, MySQL not showing Performance, Information of MySQL Schemas!

Question

This evening I installed MySQL on a new clean install of Windows 2019 server. When the install finished, the installer offered the possibility of opening Workbench so I said yes.

Then I noticed that there were schemas missing - as per the question, the performance, information and mysql schemas were missing (see the screenshot below¹)

enter image description here

But, when I log in using the mysql client, I get this

mysql> show schemas;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
6 rows in set (0.00 sec)

In Workbench, I can access the "missing" schemas via queries like so

SELECT host, user FROM mysql.user;
host,user
%,xxx
localhost,mysql.infoschema
localhost,mysql.session
localhost,mysql.sys
localhost,root

Can anybody explain to me what's going on here? How can I get the missing schemas to appear in MySQL Workbench?

¹ I know that screenshots are normally not a good idea in this forum, but this time, it's the only way to show what I mean.

>mysqld.exe --version
\mysqld.exe Ver 8.0.18 for Win64 on x86_64 (MySQL Community Server - GPL)

and

Workbench 8.0

and

Windows Server 2019 Standard

• Pang: Does this answer your question? Why isn't INFORMATION_SCHEMA not displayed in the MySQL Workbench UI by default?

Answer 1

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.

Answer 2

Just complementing on the accepted question, I was looking into that panel and could not locate such option, had to actually click the "SQL Editor" grouping to find another grouping within it called "Sidebar" that had a similar option, see screenshot below:

enter image description here