I am using Google Kubernetes Engine (GKE) to deploy MySQL. Recently, I upgraded to mysql:latest image, which now points to MySQL 9.0. Since MySQL 9.0 completely removed the mysql_native_password authentication plugin, I can no longer connect to the MySQL console, nor can I update my root account to caching_sha2_password.