Bug #79105 Backticks in user/host specifiers (redux)
Submitted: 3 Nov 2015 23:59 Modified: 10 Dec 2015 14:41
Reporter: Felipe Gasper (OCA) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[3 Nov 2015 23:59] Felipe Gasper
Description:
Bug #35902 was supposed to produce corrected documentation to mention the interchangeability of single quotes and backticks for user/host specifiers.

That did not happen.

This case is being opened to correct the missing information in the documentation.

How to repeat:
Pull up any MySQL 5+ docs on GRANT, SHOW GRANTS, or CREATE USER.
[10 Dec 2015 14:41] Paul DuBois
re: "That did not happen."

Yes, it did.

Individual statement descriptions in general no longer give much information about account name syntax. Instead, they say something like:

Each account name uses the format described in Section 6.2.3, “Specifying Account Names”.

And that section provides the details:

Quote user names and host names as identifiers or as strings, using either backticks (“`”), single quotation marks (“'”), or double quotation marks (“"”).