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

Bug #102382	Users and Privileges Page Not Working
Submitted:	26 Jan 2021 21:27	Modified:	1 Feb 2021 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:	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.

I too am experiencing this same issue.  Brand new server Windows 2019.  Brand new install of MySQL from community install 5.6.51.0.  Installed only MySQL Server and MySQL Workbench.  Workbench is version 8.0.23.

I proceeded to uninstall everything and reinstall thinking that might help but it made no difference.

MySQL Workbench showing all users and privileges tabs disabled

Attachment: MySQL Workbench.png (image/png, text), 29.72 KiB.

I was able to get around this issue by uninstalling workbench 8 and installing workbench 6.3 instead.  I'm guessing 8 does not play nice with the older versions of MySQL (in my case 5.6).

Experiencing same issue with 8.0.28

mysql workbench screen shot

Attachment: mysqlWorkbench8.0.28.PNG (image/png, text), 122.50 KiB.

I have the same issue

Windows Server 2019 (VM)
mysql workbench 8.0.28

I also have the same issue.
Mac OS Monterey 12.3.1
MySql Workbench 8.0.29

I experienced the same problem with WB 8.0.29 and MySql version 5.5.62-0ubuntu0.14.04.1. It is solved by downgrading WB to 8.0.19

Did anybody find a workaround? 
The same issue. Workbench 8.0.31, Mac version. "User and Privileges" is grey out in one laptop but works in the other. Uninstall, delete ~/Library/... and installing workbench didn't work.

Assuming you're using an older version of MySQL, you need to also use an older version of Workbench.  Workbench 6.3 works with MySQL 5.6.