Error: Unable to Authenticate to Binlog

Issue

While following the MySQL setup guide, the following error appears:

Unable to authenticate to Binlog. Try creating the Fivetran user using the 'mysql\_native\_password' password plugin.

Environment

Connector: MySQL

Resolution

To resolve this issue, do one of the following:

• Recreate the Fivetran user with the old password plugin. Do the following:

  1. Create the user. CREATE USER fivetran@'%' IDENTIFIED WITH mysql_native_password BY 'password';

  2. Grant access to the user. GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO fivetran@'%';

• Modify the MySQL configuration file and restart the instance. Do the following:

  1. Add default-authentication-plugin=mysql_native_password in the MySQL configuration file.

  2. Restart the instance.

Cause

MySQL 8 uses SHA2 for hashing passwords.