Bug #69056 Error executing grant query on schema containing underscores
Submitted: 24 Apr 2013 14:47 Modified: 24 Apr 2013 15:30
Reporter: Test Test Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.47 OS:Windows (Win7 x64 Professional SP1)
Assigned to: CPU Architecture:Any
Tags: backslash, grant, underscore

[24 Apr 2013 14:47] Test Test
Description:
Error executing grant query on schema containing underscores. Workbench escapes underscores incorrectly with a backslash, which causes a syntax error.
This error does not occur on version 5.2.44

How to repeat:
Administration -> Users and Privileges -> Add Entry:
- Any Host
- Selected schema: any schema containing underscores in its name
Hit OK to add entry.

Select a few privileges and hit Save Changes to trigger the error

Suggested fix:
Downgrade to 5.2.44
[24 Apr 2013 15:30] MySQL Verification Team
Thank you for the bug report.

Duplicate of http://bugs.mysql.com/bug.php?id=68175 .