Bug #68475 Error on set schema privileges if database name contains '_' symbol.
Submitted: 24 Feb 2013 2:37 Modified: 24 Feb 2013 7:47
Reporter: xzv xzc Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.47 OS:Linux (rev 10398)
Assigned to: CPU Architecture:Any
Tags: MySQL Workbench

[24 Feb 2013 2:37] xzv xzc
Description:
If database name contains '_' symbol, the command 'Save changes' returns error in the schema privileges.

The error:

Error executing 'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE, TRIGGER ON db\_test.* TO 'user'@'localhost''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\_test.* TO 'user'@'localhost'' at line 1.

How to repeat:
Create a database with the name db_test. Then create a user for i.e testuser and try to assing the rights for the db_test database.
[24 Feb 2013 7:47] MySQL Verification Team
Hello!

Thank you for the bug report, duplicate of http://bugs.mysql.com/bug.php?id=68175