Bug #49069 Administrative Roles seem incorrect
Submitted: 24 Nov 2009 20:38 Modified: 28 Jan 2010 14:32
Reporter: Todd Farmer (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2 r4753 OS:Windows (XP)
Assigned to: CPU Architecture:Any

[24 Nov 2009 20:38] Todd Farmer 
Description:
Looking at the root account, I see that the "DBA", "SecurityAdmin" and "DBDesigner" roles are unchecked.  That seems incorrect, given this grant:

mysql> show grants;
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
1 row in set (0.00 sec)

How to repeat:
Check roles for root account.

Suggested fix:
Probably ensure that "ALL PRIVILEGES" includes all roles.
[28 Jan 2010 14:32] Alfredo Kojima 
Marking it as duplicate of bug #49070 as they both result from the same underlying issue