MySQL 8.0: caching_sha2_password problem

The easiest way to fix that would be to alter you existing user with the following:

ALTER USER 'your-root-user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your-root-password';

ALTER USER 'your-root-user'@'%' IDENTIFIED WITH mysql_native_password BY 'your-root-password';