gdha / k3s-intro Goto Github PK

kubectl get services -n mysql
NAME                   TYPE           CLUSTER-IP      EXTERNAL-IP     PORT(S)          AGE
local-database-mysql   ClusterIP      10.43.219.239   <none>          3306/TCP         69s
mysql-svc              LoadBalancer   10.43.141.222   192.168.33.13   3306:30689/TCP   4s

Press any key to continue

On which worker node is the database running?
kubectl get pods -n mysql local-database-mysql-6c9fc799c5-46lgh -o wide
NAME                                    READY   STATUS    RESTARTS   AGE   IP          NODE    NOMINATED NODE   READINESS GATES
local-database-mysql-6c9fc799c5-46lgh   1/1     Running   0          79s   10.42.2.6   node3   <none>           <none>

Press any key to continue
Connecting to database on 192.168.33.13

Type "exit;" to exit from database
mysql -h 192.168.33.13 -P3306 -u root -pr00tpassw0rd
mysql: [Warning] Using a password on the command line interface can be insecure.
exit;

ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.33.13' (110)

Press any key to continue
Connect to mysql database via host system (mysql-client must be installed).
Copy/paste the following on another terminal window (e.g. Linux or OS/x host) :
-----------------------------------------------------------------------------
mysql -h 192.168.33.13 -P3306 -u root -pr00tpassw0rd
-----------------------------------------------------------------------------
Type "exit;" to exit from database

root@node1:/vagrant# mysql -h 192.168.33.13 -P3306 -u root -pr00tpassw0rd
mysql: [Warning] Using a password on the command line interface can be insecure.

^C
root@node1:/vagrant# mysql -h 192.168.33.13 -P30689 -u root -pr00tpassw0rd
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 47
Server version: 5.7.28 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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> exit;
Bye