MySql version 8 had no success whatsoever. with clean install and legacy options, even adding the lane to force native password.

I found info elsewhere suggesting 5.7 which resolved the issue related to cached password.

https://dev.mysql.com/downloads/windows/installer/5.7.html