Replication Not Working in MySQL 8.0. The I/O Thread Cannot Connect, Fails With Error 2061
(Doc ID 2423671.1)
Last updated on FEBRUARY 03, 2019
MySQL Server - Version 8.0 and later Information in this document applies to any platform.
Using MySQL 8.0 and a replication user that is using the default authentication plugin on the replication master (the caching_sha2_password authentication plugin), the replication I/O thread fails to start with the error:
Note that the replication is not using SSL.
The issue may appear to be intermittent, for example replication starts working after manually connecting from the host with the replication slave to the replication master using the mysql command-line client with the same credentials as the replication. Then after restarting the replication master, the replication stops working again.
The issue happens after installing MySQL Server 8.0.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!