[Solved] MYSQL Master-Slave slave I/o for channel, error_code 1045

1. Background

A few days ago, a friend restarted the master database. The master-slave link was broken and “error_code 1045” was reported.

2. Solve

From the point of view of the error, it is because of a problem with the link authentication. You can compare whether the password is consistent with the password of the master_info file of the slave library. Most of them are caused by inconsistent passwords for some reason.


stop slave;
change master to master_password='new_password';
start slave;

Read More: