1. Stop MySQL Service
2. Delete all relay logs in the MySQL log directory
3. Delete all hostname-relay-bin.xxx under Mysqldata directory, Hostname-relay-bin.index and Relay-log.info
3. Restart MySQL Service
4. Restart the master and slave
Mysql> Show Slave status \g
1. Row ***************************
Slave_io_state:waiting for Master to send event
master_host:172.168.3.190
Master_user:slave
master_port:12148
Connect_retry:60
master_log_file:binlog.000002
read_master_log_pos:106
relay_log_file:relaybinlog.000002
relay_log_pos:248
relay_master_log_file:binlog.000002
Slave_io_running:yes
Slave_sql_running:yes
replicate_do_db:
replicate_ignore_db:
Replicate_do_table:
Replicate_ignore_table:
Replicate_wild_do_table:
Replicate_wild_ignore_table:mysql.%
last_errno:0
Last_error:
skip_counter:0
exec_master_log_pos:106
relay_log_space:399
Until_condition:none
Until_log_file:
until_log_pos:0
Master_ssl_allowed:no
Master_ssl_ca_file:
Master_ssl_ca_path:
Master_ssl_cert:
Master_ssl_cipher:
Master_ssl_key:
seconds_behind_master:0
Master_ssl_verify_server_cert:no
last_io_errno:0
Last_io_error:
last_sql_errno:0
Last_sql_error:
1 row in Set (0.00 sec)
Windows MySQL Master-slave appears failed to open the relay log (Relay_log_pos 248) workaround