My Oracle Support Banner

Replication Not Working in MySQL 8.0. The I/O Thread Cannot Connect, Fails With Error 2061 (Doc ID 2423671.1)

Last updated on JULY 16, 2018

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

The issue happens after installing MySQL Server 8.0.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.