MySQL Bugs: #91414: Users and privileges tab of Administration never gets populated

Bug #91414	Users and privileges tab of Administration never gets populated
Submitted:	25 Jun 2018 15:52	Modified:	29 Jun 2018 21:30
Reporter:	Robin Bailey	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S1 (Critical)
Version:	8.0.11	OS:	Windows (Microsoft Windows 10 Home)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
See How to repeat!

How to repeat:
Open Workbench
Open connection to known working database
Open SQL query tab and run simple short query to verify that the database server is running OK.
Click on Administration tab... Users and privileges
New tab appears where U&P info should appear, but most of the controls and all of the data is missing. "Add account" and "Refresh" buttons are there, but do nothing.
On an earlier version of WB, on a different machine, the tab works fine.

Thank you for the bug report. I couldn't repeat this issue i.e.: Add account works. Which server version are you using?. Thanks.

Connections tab is OK

Attachment: Connections.PNG (image/png, text), 312.16 KiB.

Server tab is also OK

Attachment: Server.PNG (image/png, text), 448.29 KiB.

But Users tab is empty

Attachment: Users.PNG (image/png, text), 248.54 KiB.

Server is version 5.5.56.
See screenshots I've just uploaded for the incorrect behaviour.

BTW, thanks for the prompt responses! Appreciated.

Hello Robin Bailey,

Thank you for the bug report.
This is most likely duplicate of Bug #85079, please see Bug #85079

Thanks,
Chiranjeevi.

Just reviewed #85079 and think this isn't the same bug. In 85079 the User page is populated with users and the bug is that privileges can't be set, whereas in get nothing on the page at all. See the screenshot I attached earlier.

Also, the last line of the wb.log I also attached:

[ERR][wb_admin_utils.py:page_activated:319]: Exception activating the page - local variable 'logged_servername' referenced before assignment

Is this relevant?

Thanks

Hello Robin Bailey,

Thank you for the feedback.
Verified this behavior on MySQL Workbench in 8.0.11 with MySQL 5.5.60 and 5.6.40 versions on Windows 10.

Thanks,
Chiranjeevi.

Screenshot

Attachment: Bug_91414.PNG (image/png, text), 52.92 KiB.

Posted by developer:
 
I'm able to reproduce it in 8.0.11 but not on the latest dev (8.0.12).

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

Some of the controls and data were not shown within the
Administration-Users and Privileges tab.

Thank you for the bug report.