Not connecting with MySQL Daemon and user running with Authentication Plugin 'caching_sha2_password'

[gmpassos]

Currently is impossible to connect to a MySQL Daemon with a user using the new Authentication Plugin caching_sha2_password (the default for the latest MySQL version).

The only way to circumvent that is starting the daemon with the parameter: --default-authentication-plugin=mysql_native_password

Or adding to the MySQL configuration file:

[mysqld]
default-authentication-plugin=mysql_native_password

The configuration above will force new users to be created with the previous authentication plugin mysql_native_password.

Note that the user at table mysql.user should be using mysql_native_password in the columnplugin, and not caching_sha2_password, to circumvent the issue.