caching_sha2 auth update

[ixcat]

Connecting to mysql 8 (percona 8.0.19-10) yields an Authentication plugin 'caching_sha2_password' cannot be loaded: error.

Apparently MySQL 8 uses this as default (https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html), so mym should also eventually support it out of the box. Am guessing this means recompile against latest connector libs, but also probably need to cross check compatibility for older versions.

As a workaround, I was able to override the authentication for my user using:

mysql> alter user 'bob'@'localhost' IDENTIFIED WITH mysql_native_password by 'nocharlie';

Server wide settings can be adjusted with default_authentication_plugin=mysql_native_password, restart required