Bug #69404 Can't assign schema privileges
Submitted: 5 Jun 2013 11:58 Modified: 5 Jun 2013 12:23
Reporter: Tony Freixas Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.47 CE OS:Windows (Windows 7)
Assigned to: CPU Architecture:Any
Tags: privileges grant

[5 Jun 2013 11:58] Tony Freixas
Description:
When I try to assign schema privileges to a user, I get a syntax error, SQL error 1064. I'll add a screen shot to show the error message. The syntax appears correct. In fact, if I execute the command that is displayed in the error dialog, it works.

As an aside, it would be nice if I could copy/paste the error.

How to repeat:
Go to Server Administration and open a connection.
Select the "Users and Privileges" task
Select the Schema Privileges tab
Add an entry.
Click on 'Select "ALL"'
Click on Save Changes

Suggested fix:
No idea.
[5 Jun 2013 12:01] Tony Freixas
The server I'm using is MySQL 5.5.8.
[5 Jun 2013 12:17] MySQL Verification Team
Thank you for the report.
Duplicate of http://bugs.mysql.com/bug.php?id=68175