I am trying to set up MySQL Master-Slave Replication.
I have successfully done everything except Starting and Testing my Replication, after entering sudo mysql
, I run
CHANGE MASTER TO
MASTER_HOST='54.172.139.164',
MASTER_USER='web02',
MASTER_PASSWORD='97',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS= 107;
Yet I keep getting this 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 'SOURCE TO
SOURCE_HOST='54.172.139.215',
SOURCE_USER='web02',
SOURCE_PASSWORD='97' at line 1
I would appreciate it if I could get assistance on how to solve the problem.
New contributor
Gilbert Henyo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.