mysql 8.0 caching_sha2_password fix for kubernetes

mysql8.0-phpmyadmin-fix.sh

#!/bin/bash
# Please change values of <> placeholders as per your requirments.

# Step 1: Get mysql password from kubernetes pod, if installed from helm.
MYSQL_ROOT_PASSWORD=$(kubectl get secret --namespace <my-namespace> <mysql-secret-key> -o jsonpath="{.data.mysql-root-password}" | base64 --decode; echo)

# Step 2: Run mysql client in kubernetes
kubectl run -it --rm --image=mysql:8.0 --restart=Never mysql-client -- mysql -h <mysql-host> -u root -p$MYSQL_ROOT_PASSWORD

# Step 3: Run following query to chnage password method
# ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';