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

[26 Jan 2021 21:27] Sam Beard
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
[27 Jan 2021 6:42] MySQL Verification Team
Hello Sam Beard,

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

Regards,
Ashwini Patil
[29 Jan 2021 17:23] Sam Beard
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
[1 Feb 2021 5:29] MySQL Verification Team
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
[15 Mar 2021 8:10] Klaus Riech
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.
[15 Mar 2021 8:15] Klaus Riech
screenshot workbench 8.0.23: tab 'users and priviliges'

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

[18 Nov 2021 23:20] Vincent Wansink
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.
[18 Nov 2021 23:21] Vincent Wansink
MySQL Workbench showing all users and privileges tabs disabled

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

[18 Nov 2021 23:25] Vincent Wansink
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).
[2 Feb 2022 20:57] Boris Yakovich
Experiencing same issue with 8.0.28
[22 Apr 2022 16:21] Murphy Tsang
mysql workbench screen shot

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

[22 Apr 2022 16:23] Murphy Tsang
I have the same issue

Windows Server 2019 (VM)
mysql workbench 8.0.28
[26 Apr 2022 8:01] Duncan Walling
I also have the same issue.
Mac OS Monterey 12.3.1
MySql Workbench 8.0.29
[9 Jun 2022 11:07] Dave Hellings
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
[18 Oct 2022 12:03] Arjang Chinichian
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.
[18 Oct 2022 14:43] Vincent Wansink
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.