MySQL master server

#mysql主从服务器

mysql-bin.003673 | 106

Viewing the error log
Show variables like '%log_error% ';

Replicate-do-table=testmysql

Change Master to master_host= ' 182.61.28.4 ', master_user= ' Mysync ',
Master_password= ' 123456 ', master_log_file= ' mysql-bin.003673 ', master_log_pos=511;
Slave I/o: Fatal error:the Slave I/O thread stops because master and Slave have equal MySQL server IDs; These IDs must be different for replication to work (or the--replicate-same-server-id option must is used on slave but th is does do sense; Please check the manual before using it). error_code:1593
180607 10:04:08 [Note] Slave I/O thread exiting, read up to log ' mysql-bin.003673 ', position 511

MySQL master server