MySQL Workbench, Windows Server 2019, MySQL not showing Performance, Information of MySQL Schemas!
3
votes
2
answers
1420
views
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**1**)
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

Asked by PHB
(33 rep)
Nov 27, 2019, 09:48 PM
Last activity: May 3, 2025, 10:15 PM
Last activity: May 3, 2025, 10:15 PM