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
There are two solutions available to solve this error:
1. Recreate the Fivetran user with the old password plugin
Create the user.
CREATE USER fivetran@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO fivetran@'%';
2: Modify the MySQL configuration file and restart the instance
default-authentication-plugin=mysql_native_passwordin the MySQL configuration file.
- Restart the instance.
MySQL 8 uses SHA2 for hashing passwords.