Bug #87864 Cant view client connections in workbench
Submitted: 26 Sep 2017 7:35 Modified: 26 Sep 2017 19:56
Reporter: austin woz Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:6.3.9 OS:Mac OS X
Assigned to: CPU Architecture:Any

[26 Sep 2017 7:35] austin woz
When i click to view "client connections" or "Users and privileges" I get the error message 

"The account you are currently using does not have sufficient privileges to make changes to MySQL users and privileges."

However I have all the privileges required. This worked fine in versions before 6.3.9 but since upgrading this stopped working with the above error. 

I am able to see process using "show processes" in the console using the same user which confirms the user has appropriate access rights. I can also see processes using my other gui "navicat", Issue is only in Workbench 6.3.9

How to repeat:
Connect to RDS version 5.7.16, go to management then click  "client connections" or "Users and privileges"
[26 Sep 2017 19:50] MySQL Verification Team
client connections

Attachment: client_connection_on_macos-high=sierra.png (image/png, text), 2.11 MiB.

[26 Sep 2017 19:56] MySQL Verification Team
Thank you for the bug report. I created an account on remote Linux server running 5.7 and then connected from macOS High Sierra with Worbench 6.3.9 and was able to access Client Connection and User and Privileges, please check your real privileges with the server are you connected. Please see screenshot. Thanks.
[22 Oct 2018 9:11] Tuomas Kiviaho
Could it be that the privilege delegation has something to do with this. I've got the following grants.

show grants for 'myuser' 

GRANT USAGE ON *.* TO \'myuser\'@\'%\''
GRANT ALL PRIVILEGES ON \"rootuser\".* TO \'myuser\'@\'%\''