MySQL 8 default authentication plugin

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:

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';