K
Q

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

7/18/2019

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 ?

-- jeril
kubernetes
mysql

Similar Questions

using postStart to start netdata, but did not work as expected
How do I externalize property values for an Angular 7 application?
kubernetes create deployment using docker local image - image pull failed
How to scale a CRD Controller in Kubernetes
AWS EKS - Multi-cluster communication
Pilosa k8s pod crashloopbackoff with error "server : executable file not found in $PATH"
How create a alert to the resource quotas k8s to send alert for example Prometheus
How can I pull a docker image in a Kubernetes cluster from a private registry behind a ssh connection
Expose your app publicly doesn't work on local kubernetes cluster
Kubernetes Host and Service Ingress Mapping using TCP
Unable to run VSTS Agents on Kubernetes using Azure Devops
How to manage linux users with Kubernetes?

2 Answers

7/18/2019

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.

-- Malathi
Source: StackOverflow
7/18/2019

try this

mysql -u root --password=<PASSWORD> -h <CLUSTER_HOST> --port=32695
-- P Ekambaram
Source: StackOverflow