2

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)

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
1

1 Answer 1

5

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.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.