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 below1)
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?
1 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