how to access mySQL server in kubernetes

Question

I have created a MySQL deployment in kubernetes and exposed it as nodes-port.

What I can do:
Access it from inside the cluster using
kubectl run -it --rm --image=mysql:5.6 --restart=Never mysql-client -- mysql -h mysql -ppassword

What I want to do:
Access the MySQL server from outside the cluster(like accessing a normal MySQL server).
Kubernetes v1.13 in DigitalOcean Cloud.
Guide me, please.

Hansika Weerasena · Accepted Answer · 2019-01-11 05:26:17Z

3

You can access it by mysql -u {username} -p {password} -h {any kubernetes worker ip} -P {nodePort}. After you start mysql container and expose it ad node port through a service.

answered Jan 11, 2019 at 5:26

Hansika Weerasena

3,4041 gold badge17 silver badges23 bronze badges

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

3 Comments

AATHITH RAJENDRAN Over a year ago

its asking for a password @hansika

Hansika Weerasena Over a year ago

give your mysql root password. Did you specify any password when you deploy mysql?

AATHITH RAJENDRAN Over a year ago

mysql -u {username} -p -h {any kubernetes worker ip} -P {nodePort} worked for me :)

SamK · Accepted Answer · 2019-02-27 06:21:50Z

0

You need to specify the MYSQL_ROOT_PASSWORD while bringing up the pod. How were you able to bring it up in Docker without it?

answered Feb 27, 2019 at 6:21

SamK

637 bronze badges

Collectives™ on Stack Overflow

how to access mySQL server in kubernetes

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related