mysql last_io_error_[MySQL生產環境複製故障修復] Last_IO_Errno: 1045 Last_IO_Error: error connecting to master ...

-- 重新設置複製參數

mysql> change master to master_host='10.24.54.18',master_port=3306,master_user='replication',master_password='xxxxxx';

Query OK, 0 rows affected, 0 warnings (0.40 sec)

mysql> start slave;

Query OK, 0 rows affected (0.01 sec)

mysql> show slave status\G;

*************************** 1. row ***************************

Slave_IO_State: Connecting to master

Master_Host: 10.24.54.18

Master_User: replication

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000002

Read_Master_Log_Pos: 1355028

Relay_Log_File: mysql-relay-bin.000001

Relay_Log_Pos: 4

Relay_Master_Log_File: mysql-bin.000002

Slave_IO_Running: Connecting

Slave_SQL_Running: Yes

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

<