IssueTracker

This will create a public issue which anybody can view and comment on.

Please provide as much information as possible. At least, this should include a description of your issue and steps to reproduce the problem. If possible please provide a summary of what steps or workarounds you have already tried, and any docs or articles you found (un)helpful.

Problem you have encountered:
Getting a lot of Warnings in logs because gcloud default users use 'mysql_native_password' password plugin which deprecated  on Mysql 8.0.34 version according to official documentation https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html

What you expected to happen:
From Mysql 8.0.34 version default users should use different type of password plugin for default users (root, mysql.sys) and glcoud users (cloudiamgroup, cloudsqlreplica, cloudsqlsuperuser,  cloudsqlexport, cloudsqlimport, cloudsqloneshot, cloudsqlapplier). For example mysql.infoschema and mysql.session use caching_sha2_password plugin, which is the default the default authentication plugin https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html

Steps to reproduce:
Update to a mysql gcloud sql database to Mysql 8.0.34 version, make few queries to the database, check logs.


Other information (workarounds you have tried, documentation consulted, etc):
Changed mine mysql users to 'caching_sha2_password' plugin password, but still getting the warnings because of gcloud users.
Changed manually cloudsqloneshot user plugin from mysql_native_password to caching_sha2_password, warnings stopped. After that tried to to enable a new flag 'default_authentication_plugin' : 'caching_sha2_password', but database could not load on restart and stuck in updating state, reported in https://issuetracker.google.com/issues/296739709