Plugin ‘caching_sha2_password’ cannot be loaded
Trying to connect to from MySQL Workbench to a MySQL Server I got the following error:
Authentication plugin 'caching_sha2_password' cannot be loaded
The solution was to alter the user in order to change the encryption of the password.
ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';