Plugin ‘caching_sha2_password’ cannot be loaded

Issue Description:

Trying to connect to from MySQL Workbench to a MySQL Server I got the following error:
Authentication plugin 'caching_sha2_password' cannot be loaded

Solution:

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

Related Posts