MySQL Bugs: #102382: Users and Privileges Page Not Working

Bug #102382	Users and Privileges Page Not Working
Submitted:	26 Jan 21:27	Modified:	1 Feb 5:29
Reporter:	Sam Beard	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	8.0.23	OS:	Microsoft Windows (Windows 10 Pro)
Assigned to:		CPU Architecture:	Any

Description:
Users and Privileges page has all tabs disabled when connected to DB version 5.6.39-1+7.1-log((Debian)).  Users could be selected, "Details for account xxx" changed but was greyed out and all tabs were greyed out.

When connected to 5.7 DBs there was no issue.

User has GRANT ALL PRIVILEGES ON *.* WITH GRANT OPTION

The only errors in the log are initial login attempts with PASSWORD NO, a warning about a duplicate plugin and the error "Unable to create db_mgmt_SSHConnectionRef object" which looks a little suspicious.

The log I will attach shows attaching to multiple databases and database versions including a 5.5 DB (not supported) the simeon-a database is the one with the issue.  

Reloaded Workbench 8.0.19 and there are no issues

How to repeat:
Connect WB 8.0.23 to DB 5.6.39 and try to use Users and Privileges

Hello Sam Beard,

Thank you for the bug report.
Could you please provide screenshot of the issue? Thanks.

Regards,
Ashwini Patil

I am unable to get that screen shot right now.

I uninstalled the new version and reinstalled 8.0.19 which I had been previously using successfully.

Next week I may be able to reload the new release and try again.

Sam

Hello Sam,

Thank you for the details. 
I tried to reproduce your issue on windows 10 with workbench 8.0.23 but I am not seeing any issues at my end. 

Regards,
Ashwini Patil

Exaclty the same phenomenon here.
Same build. All tabs within the "Users and Priviliges" tab greyed out.
I will add the requested screenshot.

I actually checked wheter I can change the passwords etc. using SQL commands like SET PASSWORD and it works. So I do have the rights - but workbench doesn't give me access to the proper interface.

screenshot workbench 8.0.23: tab 'users and priviliges'

Attachment: 2021_03_15_09_11_19_Window.png (image/png, text), 128.44 KiB.