How do I connect to a remote mysql kubernetes pod using mysql client

Question

I have a got a kubernetes mysql pod which is exposed as a nodePort like shown below

apiVersion: v1
kind: Service
metadata:
  name: demo-mysql
  labels:
    app: demo
spec:
  type: NodePort
  ports:
    - port: 3306
      nodePort: 32695

I am trying to access this mysql server using the command below

mysql -u root -h 117.213.118.86 -p 32695

but I get this error

ERROR 2003 (HY000): Can't connect to MySQL server on '117.213.118.86' (111)

What am I doing wrong here ?

P Ekambaram · Accepted Answer · 2019-07-18 06:37:41Z

1

try this

mysql -u root --password=<PASSWORD> -h <CLUSTER_HOST> --port=32695

answered Jul 18, 2019 at 6:37

P Ekambaram

17.9k9 gold badges46 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Malathi · Accepted Answer · 2019-07-18 05:17:49Z

1

If you want to connect to a remote mysql service, you have to specify an endpoint that has the remote service's ip addrress like this:

apiVersion: v1
kind: Endpoints
metadata:
  name: demo-mysql
subsets:
  - addresses:
      - ip: 192.0.2.42
    ports:
      - port: 3306

More details here.

answered Jul 18, 2019 at 5:17

Malathi

2,21517 silver badges42 bronze badges

Collectives™ on Stack Overflow

How do I connect to a remote mysql kubernetes pod using mysql client

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related