MySQL Bugs: #92212: Schema navigator not displaying

Bug #92212	Schema navigator not displaying
Submitted:	28 Aug 2018 13:26	Modified:	29 Aug 2018 0:55
Reporter:	Carlo Barranco	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.12	OS:	MacOS
Assigned to:		CPU Architecture:	Any
Tags:	navigator

Description:
What I did: Opened MySQL Workbench

What I expected to happen: to see the list of schemas in the schema navigator on the left

What happened: schema navigator is not displaying.

All the rest works fine. 
I can run queries, create tables and schemas, see results, exports them, show processes and users. I simply can't see the handy list of schemas on the navigator.

Can someone please help? 
Is there a setting or a preference to select (or de-select) to be able to see again the schema navigator?

How to repeat:
Quit MySQL workbench and open it again, then connect to any of the existing connections.

Thank you for the bug report. Are you using version 8.0.12 Otherwise please update.

Thank you Miguel Solorzano to remind me to check. 
My version is 6.3.10. I'll update to 8.0.12 and check again.

Just updated to the latest version, the problem is still there.

Schema List on MAC with 8.0.12

Attachment: 92212.png (image/png, text), 1.14 MiB.

Thank you for the feedback. Please see attached picture, which server version are you using?.

What I see

Attachment: Screen Shot 2018-08-28 at 14.18.47.png (image/png, text), 250.88 KiB.

Hi Miguel Solorzano, 
I'm not sure I'm understanding what you mean about server version.
I've added an image about what I see.
i used to be able to see the the list of schemas on the left as in your image, using this same machine, but now I can't.
Is there an option that could have been unwillingly selected that prevents me from seeing it?

With mysql version I meant which is the version of the server are you connected to i.e: MySQL server 5.7.23. What is limiting you to list the schemas is the privileges of the user are you using to connect to, below I show you a root user with high privileges and create an x user with low privileges:

C:\DBS>8.0\bin\mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
5 rows in set (0.00 sec)

mysql> create user 'x'@'%' identified by 'limited';
Query OK, 0 rows affected (0.11 sec)

mysql> exit
Bye

C:\DBS>8.0\bin\mysql -ux -p
Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)

mysql>

The above it could be one reason to prevent WorkBench to list the schemas, short is the limited user privileges for.

To be clear, about the user with low privileges to show partial schemas I meant could be one of the reasons.

Hi,
I've no problem displaying all databases from commands using current connection.
I can run with no problem all the following commands

show databases ;
create database delete_me_when_done ;
create table delete_me_when_done.delete_me_when_done ( id int(2) primary key, blabla varchar(10) ) ;
show tables in delete_me_when_done ;
describe delete_me_when_done.delete_me_when_done ;
# gives back the expected results
/*
Field, Type, Null, Key, Default, Extra
id, int(2), NO, PRI, , 
blabla, varchar(10), YES, , , 
*/
drop table delete_me_when_done.delete_me_when_done ; 
drop database delete_me_when_done ; 

If I ran 
SHOW VARIABLES LIKE "%version%" ;
I obtain

Variable_name, Value
innodb_version, 5.6.36
protocol_version, 10
slave_type_conversions, 
version, 5.6.36-log
version_comment, MySQL Community Server (GPL)
version_compile_machine, x86_64
version_compile_os, Linux