Minikube. How to allow access to local mySQL database from container

Question

I'm trying to access to local MySQL database from minikube container. My minikube works on Windows 10 with hyper-v driver. I found a few solutions (creating host-only network from VirtualBox) but nothing for hyper-v. Can somebody assist me how can I connect to localhost mysql server from minikube hyper-v?

score 3 · Answer 1 · answered Oct 06 '20 at 17:02

3

Minikube v1.10 added a hostname to the cluster DNS that allows pods to connect to the host. Have your pods use this DNS entry to access the host IP. At this time, the DNS hostname is host.minikube.internal

See docs to learn more.

answered Oct 06 '20 at 17:02

levibostian

133
4

score 1 · Answer 2 · answered Mar 23 '20 at 11:56

1

First you need to create a Service and then create an Endpoint with the IP of your MySQL.

apiVersion: v1
kind: Service
metadata:
  name: database
spec:
  ports:
  - port: 3306
    targetPort: 3306
    protocol: TCP
---
# Because this service has no selector, the corresponding Endpoints
# object will not be created. You can manually map the service to
# your own specific endpoints:
kind: Endpoints
apiVersion: v1
metadata:
  name: database
subsets:
  - addresses:
      - ip: "23.99.34.75"
    ports:
      - port: 3306

Also you can check this question Connect to local database from inside minikube cluster.

answered Mar 23 '20 at 11:56

Crou

739
3
10

Thanks for answer. How can I get mySql IP? Is it my external IP? – Denis Lopatin Mar 23 '20 at 12:34
I would deploy that MySQL inside a docker container so it would be easy to connect to. – Crou Mar 23 '20 at 12:55
1

It is like an option. I thought about this. But for me looks like an extra job. – Denis Lopatin Mar 23 '20 at 12:58

score 0 · Answer 3 · answered Jun 14 '23 at 13:20

Get your host ip by HOST_IP=$(minikube ssh "route -n | grep ^0.0.0.0 | awk '{ print \$2 }'")

According to K8s docs apply:

apiVersion: v1
kind: Service
metadata:
  name: mysql-db
spec:
  ports:
  - port: 3306
    targetPort: 3306
    protocol: TCP

---
kind: EndpointSlice
apiVersion: discovery.k8s.io/v1
metadata:
  name: mysql-db-endpoint
  labels:
      kubernetes.io/service-name: mysql-db
addressType: IPv4
ports:
  - port: 3306
    name: ''
    appProtocol: http
    protocol: TCP
endpoints:
  - addresses:
      - $HOST_IP

Minikube. How to allow access to local mySQL database from container

3 Answers3