List:General Discussion« Previous MessageNext Message »
From:Machiel Richards Date:February 16 2011 3:15pm
Subject:MySQL 5.1 change master syntax issues?
View as plain text  
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: machielr@stripped
Thread
• MySQL 5.1 change master syntax issues?Machiel Richards16 Feb