Helm/PhpMyAdmin

helm repo add bitnami https://charts.bitnami.com/bitnami
helm repo update && helm repo list
kubectl config get-contexts

Config

export KUBECONFIG="${HOME}/.kube/dev-kubeconfig.yaml"
export KUBECONFIG="${HOME}/.kube/gcp-kubeconfig.yaml"
export KUBECONFIG="${HOME}/.kube/config"

Install

helm show values bitnami/phpmyadmin --version=17.0.0|less helm show values bitnami/phpmyadmin --version=17.0.9|less	kubectl get ns|grep phpmyadmin kubectl delete ns phpmyadmin	kubectl get ns|grep phpmyadmin kubectl create ns phpmyadmin
cat <<YML | helm -n phpmyadmin install phpmyadmin bitnami/phpmyadmin --version=17.0.9 -f - --- ingress: enabled: true ingressClassName: nginx hostname: mariadb.k8s.local path: / fullnameOverride: phpmyadmin YML
echo -n password: ;read -s MYSQL_PWD;export MYSQL_PWD;echo mariadb -hmariadb.k8s.local -p3306 -uacademia academia mariadb -hmariadb.k8s.local -p3306 -uroot mysql	echo -n password: ;read -s MYSQL_PWD;export MYSQL_PWD;echo mariadb 'mariadb://[email protected]:3306/academia' mariadb 'mariadb://[email protected]:3306/mysql'

Patch » config

kubectl -n phpmyadmin get deploy/phpmyadmin -oyaml|yq -r '.spec.template.spec.containers[]|select(.name=="phpmyadmin").volumeMounts[]|select(.name=="myadmin-config" and .subPath=="config.inc.php")'
kubectl -n phpmyadmin get deploy/phpmyadmin -oyaml|yq -r '.spec.template.spec.containers[]|select(.name=="phpmyadmin").volumeMounts[]|select(.name=="myadmin-config")'
kubectl -n phpmyadmin get deploy/phpmyadmin -oyaml|yq -r '.spec.template.spec.volumes[]   |select(.name=="myadmin-config")'

cat <<YML | kubectl -n phpmyadmin patch deploy/phpmyadmin --patch-file=/dev/stdin
---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: phpmyadmin
  namespace: phpmyadmin
spec:
  template:
    spec:
      containers:
      - name: phpmyadmin
        volumeMounts:
        - name: myadmin-config
          mountPath: /opt/bitnami/phpmyadmin/config.inc.php
          subPath: config.inc.php
      volumes:
      - name: myadmin-config
        configMap:
          name: config-inc-php
          items:
          - key: config.inc.php
            path: config.inc.php
YML

Uninstall

helm uninstall -n phpmyadmin phpmyadmin
kubectl delete namespace phpmyadmin

Swiss Knife

kubectl -n mariadb run -i --tty --rm mariadb-client --image=alpine --restart=Never -- sh
echo -n password: ;read -s MYSQL_PWD;export MYSQL_PWD; echo
apk --update add --no-cache mariadb-client inetutils-telnet

mariadb -hmariadb.mariadb.svc.cluster.local -uroot academia
mariadb -hmariadb.mariadb.svc -uroot academia
mariadb -hmariadb.mariadb -uroot academia
mariadb -hmariadb -uroot academia

Playground

helm -n phpmyadmin install phpmyadmin bitnami/phpmyadmin --version=17.0.0 helm -n phpmyadmin upgrade -i phpmyadmin bitnami/phpmyadmin --version=17.0.9 helm show values bitnami/phpmyadmin --version=17.0.9|less
kubectl -n phpmyadmin exec -it svc/phpmyadmin -c phpmyadmin -- mariadb -hhost.minikube.internal -uchorke -p kubectl -n phpmyadmin exec -it svc/phpmyadmin -- cat /opt/bitnami/phpmyadmin/config.inc.php kubectl -n phpmyadmin exec -it svc/phpmyadmin -- ls -lah /opt/bitnami/phpmyadmin/|grep config kubectl -n phpmyadmin exec -it svc/phpmyadmin -c phpmyadmin -- bash kubectl -n phpmyadmin exec -it svc/phpmyadmin -- mariadb --help
kubectl config --kubeconfig=${HOME}/.kube/aws-kubeconfig.yaml view --flatten kubectl config --kubeconfig=${HOME}/.kube/dev-kubeconfig.yaml view --flatten kubectl config --kubeconfig=${HOME}/.kube/gcp-kubeconfig.yaml view --flatten kubectl config --kubeconfig=${HOME}/.kube/config view --flatten
kubectl -n phpmyadmin delete all --all kubectl -n phpmyadmin delete ing --all kubectl -n phpmyadmin delete sts --all	kubectl -n phpmyadmin delete svc --all kubectl -n phpmyadmin delete pvc --all kubectl -n phpmyadmin delete pv --all
kubectl -n phpmyadmin rollout history deploy phpmyadmin kubectl -n phpmyadmin rollout restart deploy phpmyadmin kubectl -n phpmyadmin rollout status deploy phpmyadmin	kubectl -n phpmyadmin exec -it svc/phpmyadmin -- mariadb --help kubectl -n phpmyadmin logs -f svc/phpmyadmin -c phpmyadmin kubectl -n phpmyadmin logs -f svc/phpmyadmin

References

Helm » Pass YAML/JSON using stdin Helm » Prometheus Stack Helm » Cert Manager Helm » phpmyadmin Helm » MariaDB Helm
K8s » Configure Service Accounts for Pods K8s » Restart Pods With Kubectl K8s » Interactive Pod K8s » Restart Pods Docker » Makefile Kubernetes Minikube Kubectl CURL K8s	K8s » kubectl rollout K8s » CSI Hostpath Driver K8s » Ingress K8s » Service K8s » Run MinIO CIDR UFW Port