error 2059 (hy000) authentication plugin 'caching_sha2_password' cannot be loaded

Error:

error 2059 (hy000) authentication plugin 'caching_sha2_password' cannot be loaded


Solución:


ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';

Fuente: https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded