Depending what you are running on you would need to enable host access. I tested with minikube and was able to use host.minikube.internal
as the sql host:
helm install -f values/values.mysql.yaml temporaltest \
--set elasticsearch.enabled=false \
--set prometheus.enabled=false \
--set grafana.enabled=false \
--set server.config.persistence.default.sql.user=myuser \
--set server.config.persistence.default.sql.password=mypassword \
--set server.config.persistence.visibility.sql.user=myuser \
--set server.config.persistence.visibility.sql.password=mypassword \
--set server.config.persistence.default.sql.host=host.minikube.internal \
--set server.config.persistence.visibility.sql.host=host.minikube.internal . --timeout 900s
Just make sure that locally your mysql user has a non-blank password (if you use root by default its blank so make sure you set it to something) cause there seems to be a small issue with having blank password for sql in helm charts atm, investigating.