MySQL changing authentication type from standard to caching_sha2_password

I had the same problem today. The only way I found to fix it was:

1. executing the install file
2. select “Reconfigure” over the mysql server
3. In Authentication Method tab, select “Use Legacy Authentication Method”

It should fix your problem.