1. To get a MySQL prompt inside your new cluster you can run:

    ROOT_PASSWORD=`kubectl -n {{ .Release.Namespace }} get secrets {{ include "pxc-database.fullname" . }} -o jsonpath="{.data.root}" | base64 --decode`
    kubectl -n {{ .Release.Namespace }} exec -ti \
      {{ include "pxc-database.fullname" . }}-pxc-0 -- mysql -uroot -p"$ROOT_PASSWORD"

2. To connect an Application running in the same Kubernetes cluster you can connect with:

{{- if .Values.proxysql.enabled }}
    ROOT_PASSWORD=`kubectl -n {{ .Release.Namespace }} get secrets {{ include "pxc-database.fullname" . }} -o jsonpath="{.data.root}" | base64 --decode`

{{- else }}

{{- end }}


$ kubectl run -i --tty --rm percona-client --image=percona --restart=Never \
  -- mysql -h {{ template "pxc-database.fullname" . }}-proxysql.{{ .Release.Namespace }}.svc.cluster.local -uroot -p"$ROOT_PASSWORD"