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.

Solution:

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

Read More:

• [Solved] Mysql Build Error: [ERROR] Slave I/O for channel ‘‘: error connecting to master
• MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id
• [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
• (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
• MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
• [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!
• [Solved] Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘event read from binlog did not pass crc check; the first event
• Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
• MySQL Workbench: Error Code: 1175 [How to Solve]
• [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
• [Solved] Error Code: 2013. Lost connection to MySQL server during query
• [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
• mysql workbench Error Code: 1046. No database selected Select the default DB to be used by doubl
• MySQL startup error: vcruntime140_1.dll cannot be found, unable to continue code execution
• [Solved] Mysql Close safe-updates Mode Error: Error Code: 1175
• Mysql Script Error Code: 1136. Column count doesn’t match value count at row 1
• MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
• [Solved] MySQL Execute update error: error code: 1175
• [Solved] MySQL Startup Error: Job for mysqld.service failed because the control process exited with error code
• How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘