Bug #64841 Cannot give a user the Super priviledge
Submitted: 2 Apr 2012 13:33 Modified: 2 May 2012 14:10
Reporter: Richard Crawshaw Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.38 CE OS:Windows (Win 7)
Assigned to: CPU Architecture:Any

[2 Apr 2012 13:33] Richard Crawshaw 
Description:
Changing the Administrative Role of a user to one that includes the Super privilege causes MySql Workbench to report an error and then crash.

Attempting to do an update to the mysql.Users table causes the same error to be reported, though no crash occurs.

The error message boils down to 
Error Code: 1054. Unknown column 'CANNOT_GRANT_PRIV' in 'field list'.

This means that it isn't possible to create a trigger on a table.

How to repeat:
Change the administrative role of a user to include the Super priviledge or attempt to update the mysql.Users table:

UPDATE  mysql.user
SET     Super_priv = 'Y'
WHERE   User = <username>;
[2 Apr 2012 14:10] Valeriy Kravchuk 
What exact server version, 5.x.y, are you working with?
[3 May 2012 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".