Hi All
I am trying to setup replication between 2 mysql servers, however
when running the command below on the slave machine, I get the error as
shown below.
CHANGE MASTER TO MASTER_HOST='<IP removed>', MASTER_USER='repladmin',
MASTER_PASSWORD='<password>', master_log_file=‘mysql-bin.000620’,
master_log_pos=713184200;
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 '‘<IP>’, master_user=‘repladmin’,
master_password=‘<password>’' at line 1
I have confirmed that I am able to connect to the master using
these credentials, however Can't seem to spot my mistake in the command.
The slave server is running mysql-5.1.50 and the master server
is mysql-5.0
Machiel Richards
Relational Database Consulting (Pty) Ltd
MYSQL / POSTGRES specialist
20 Stirrup Lane, Woodmead Office Park, Van Reenens Road, Woodmead, South
Africa
Office: 0861 RDC RDC (0861 732 732)
Mobile: +27 72 238 6008
Fax: 0861 RDC FAX (0861 732 329)
E-Mail: machi...@rdc.co.za
