You can try using mysql\_native\_password or caching\_sha2\_password, then it requires a restart of your cloud SQL instance for the changes to take effect.
Go to Google Cloud Console
Edit > Flags
Change the default\_authentication\_plugin to mysql\_native\_password
Restart your Cloud SQL instance