MySQL 主-主复制

Question

我正在尝试在 MySQL 中运行以下查询:

GRANT REPLICATION SLAVE ON *.* TO 'replication'@’10.141.2.%’ IDENTIFIED BY ‘slave’;

它不断返回以下错误:

ERROR 1064 (42000): 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 '??10.141.2.%’ IDENTIFIED BY ‘slave’' at line 1

我做错了什么？

谢谢。

Answer 1

您使用的是“花哨的引号”(看看它们是如何“精简”的)？将 ' 替换为 '

'replication'@'10.141.2.%' 应该是 'replication'@'10.141.2.%'

(另外，您似乎也在 IDENTIFIED BY ‘slave’; 上这样做)