Edit on GitHub
Unable to Authenticate to Binloglink
Issuelink
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.
Environmentlink
Connector: MySQL
Resolutionlink
To resolve this issue, do one of the following:
Recreate the Fivetran user with the old password plugin. Do the following:
Create the user.
CREATE USER fivetran@'%' IDENTIFIED WITH mysql_native_password BY 'password';
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:
Add
default-authentication-plugin=mysql_native_password
in the MySQL configuration file.Restart the instance.
Causelink
MySQL 8 uses SHA2 for hashing passwords.