Bug #698 Grant bug prevents use of backslash under freebsd

• Submitted: 22 Jun 2003 22:26
• Modified: 9 Apr 2008 5:37
• Reporter: Nick Koston
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.0.12,4.0.13
• OS: FreeBSD (FreeBSD)
• CPU Architecture: Any

[22 Jun 2003 22:26] Nick Koston

Description:
 
mysql> GRANT ALL ON `cpstaff\_tsb`.* TO cpstaff@localhost;
ERROR:
Unknown command '\_'.
Query OK, 0 rows affected (0.00 sec)
 

The grant works, however it produces an error.

How to repeat:
mysql> GRANT ALL ON `cpstaff\_tsb`.* TO cpstaff@localhost;
ERROR:
Unknown command '\_'.
Query OK, 0 rows affected (0.00 sec)

[25 Jun 2003 14:03] MySQL Verification Team

This feature was planned for 4.1, where it is implemented.

[26 Jun 2003 3:52] Sergei Golubchik

It was fixed in 4.0.13

From the Changelog:
   * `mysql' command line client no longer looks for `\*' commands
     inside backtick-quoted strings.

Are you sure you tried mysql *client* from 4.0.13 ?

[9 Apr 2008 5:37] Susanne Ebrecht

Closed this bug because it was fixed in newer versions.