Windows MySQL Master-slave appears failed to open the relay log (Relay_log_pos 248) workaround

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