CODEWITHSUNDEEP
mysql
user1527556
user1527556

Reputation: 65

MySQL Master-Master Replication

I am trying to run the following query in MySQL:

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

It keeps returning the following error:

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

What am i doing wrong?

Thanks.

Upvotes: 2

Views: 208

Answers (1)

Mitch Dempsey
Mitch Dempsey

Reputation: 39939

You are using "fancy quotes" (see how they 'lean') ? Replace ’ with '

'replication'@’10.141.2.%’ should be 'replication'@'10.141.2.%'

(also, it appears you are doing it on IDENTIFIED BY ‘slave’; as well)

Upvotes: 0

Related Questions