Issue

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

Unable to authenticate to Binlog. Please try to create the fivetran user with 'mysql_native_password' password plugin

Environment

Connector: MySQL

Answer

There are two solutions available to solve this error:

1. Recreate the Fivetran user with the old password plugin

1. Create the user.

   CREATE USER fivetran@'%' IDENTIFIED WITH mysql_native_password BY 'password';

2. Grant access.

   GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO fivetran@'%';

2: Modify the MySQL configuration file and restart the instance

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.