mysql - 向名为 "Grant"的用户授予权限？

Question

CREATE USER 'Grant'@'localhost' IDENTIFIED BY 'bestpasswordever';

如何向名为“Grant”的用户授予权限？它抛出一个错误。

GRANT INSERT, DELETE
ON table
TO Grant@localhost;

错误:“授予”在此位置无效。期待一个标识符。

Answer 1

使用保留关键字或标识符时必须使用反引号，否则非法字符作为标识符

GRANT INSERT, DELETE
ON table
TO `Grant`@localhost;

根据 the documentation，撇号或双引号也可以:

Quote user names and host names as identifiers or as strings, using either backticks (`), single quotation marks ('), or double quotation marks ("). For string-quoting and identifier-quoting guidelines, see Section 9.1.1, “String Literals”, and Section 9.2, “Schema Object Names”.

...但我是一个纯粹主义者，并且总是在 MySQL 中使用反引号作为标识符。