failed to "Verify that you can connect to MySQL" according to quick start guide

[k19810703]

I followed quick start guide to start a cluster. Everythink seems fine.

➜ mysql-operator git:(master) ✗ kubectl get pods --namespace=mysqltest
NAME READY STATUS RESTARTS AGE
my-app-db-0 2/2 Running 0 31m
my-app-db-1 2/2 Running 0 27m
my-app-db-2 2/2 Running 0 24m

but in the last step , I failed to connect mysql.
➜ mysql-operator git:(master) ✗ kubectl --namespace=mysqltest run mysql-client --image=mysql:5.7 -it --rm --restart=Never
-- mysql -hmy-app-db -uroot -pxs17uXpPE5bBe5TB -e 'SELECT 1'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'10.244.1.190' (using password: YES)
pod mysqltest/mysql-client terminated (Error)

[owainlewis]

Can you double check your password is correct?

kubectl exec -n mysqltest -it my-app-db-0 /bin/bash 
env | grep MYSQL_ROOT_PASSWORD
mysql -u root -p$MYSQL_ROOT_PASSWORD

[k19810703]

@owainlewis
I can log in mysql use that password via kubectl exec
➜ ~ kubectl exec -n mysqltest -it my-app-db-0 /bin/bash
Defaulting container name to mysql.
Use 'kubectl describe pod/my-app-db-0' to see all of the containers in this pod.
bash-4.2# env | grep MYSQL_ROOT_PASSWORD
MYSQL_ROOT_PASSWORD=xs17uXpPE5bBe5TB
bash-4.2# mysql -u root -p$MYSQL_ROOT_PASSWORD
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23969
Server version: 8.0.11 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

but it doesn't work via mysql client

[ruiaylin]

you should change the hostname my-app-db to your ip address , that will work ok .

[ruiaylin]

@k19810703