MySQL Bugs: #87864: Cant view client connections in workbench

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:	None
Category:	MySQL Workbench: Administration	Severity:	S1 (Critical)
Version:	6.3.9	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
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"

client connections

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

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.

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\'@\'%\''