Sample Header Ad - 728x90

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**) 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? **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