jackchuong
commented
4 months ago My bad, I NAT service/thankyou-mysql-svc to k8s cluster using ingress nginx wrongly , I fixed issue. But I found some useful tips to enable mysql_native_password plugin , hope it helps
---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
name: thankyou-mysql-pvc
namespace: thankyou
spec:
storageClassName: nfs-idcnas002
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 5Gi
---
# config-map.yaml
apiVersion: v1
kind: ConfigMap
metadata:
## name of ConfigMap. This will be referred from volume definition
name: mysql-config
namespace: thankyou
labels:
app: mysql
data:
## default_auth is the name of config. This will be referred from volume mount definition
default_auth: |
[mysqld]
default_authentication_plugin=mysql_native_password
---
apiVersion: apps/v1
kind: Deployment
metadata:
name: utilities
namespace: thankyou
spec:
selector:
matchLabels:
app: utilities
template:
metadata:
labels:
app: utilities
spec:
containers:
- image: mysql:8.0-debian
name: thankyoumysql
env:
- name: TZ
value: "Asia/Ho_Chi_Minh"
- name: MYSQL_ROOT_PASSWORD
value: "******"
volumeMounts:
- name: thankyou-mysql-pvc
mountPath: /var/lib/mysql
- name: mysql-config-volume ## specify volume name
mountPath: /etc/mysql/conf.d/default_auth.cnf ## path to mount file
subPath: default_auth ## name of config
volumes:
- name: thankyou-mysql-pvc
persistentVolumeClaim:
claimName: thankyou-mysql-pvc
- name: mysql-config-volume ## volume name
configMap:
name: mysql-config ## name of ConfigMap
---
apiVersion: v1
kind: Service
metadata:
name: thankyou-mysql-svc
namespace: thankyou
spec:
selector:
app: utilities
ports:
- name: postgres
port: 3306
protocol: TCP
targetPort: 3306
---
Hi all, I have an internal k8s cluster , metalLB , ingress nginx , everything working fine, here my yaml
I NAT service/thankyou-mysql-svc out to k8s cluster using ingress nginx , from a computer outside k8s cluster I can telnet ingress nginx IPaddress port 3306 successfully When I use mysql client like sqlyog community 64 (on computer outside k8s cluster) connect to ingress nginx IPaddress port 3306 with username root and password I get error
Below docker-compose.yml works just fine.
Please give me some advice, thank you very much.