MySQL Bugs: #69056: Error executing grant query on schema containing underscores

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

Thank you for the bug report.

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