MySQL 8 default authentication plugin

1

When connecting local Dremio to a local MySQL 8.0.x instance, I encountered issues related to the new default authentication plugin. I worked around this by adding

[mysqld]
…
default_authentication_plugin=mysql_native_password
…

to my.cnf and

mysql > ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';

as MySQL admin.

See:
https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/

2

After doing some testing, it appears that you don’t need to change the server default. You just need to change the authentication plugin for the MySQL user account Dremio connects with:

mysql > ALTER USER 'your_dremio_user'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'new_password';