MySQL Agent fails to connect when root password contains '#'

[airdos360]

Is this a BUG REPORT or FEATURE REQUEST?

BUG REPORT

Versions

MySQL Operator Version: 0.2.0

Environment: Linux

• Kubernetes version (use kubectl version): 1.11.2
• Cloud provider or hardware configuration:
• OS (e.g. from /etc/os-release): CentOS 7

What happened?

MySQL agent will not connect when root password is set. If root password is left blank, it starts up correctly.

kubectl create secret generic -n mysql mysql-cluster-root-password --from-literal=password=XXXXXX

apiVersion: mysql.oracle.com/v1alpha1
kind: Cluster
metadata:
name: mysql-cluster
namespace: mysql
spec:
multiMaster: true
members: 3
rootPasswordSecret:
name: mysql-cluster-root-password

What you expected to happen?

Pods to start up when rootPasswordSecret is set.

[airdos360]

Seems to be if the password contains a "#" it fails. I got it to work without the #.

[prydie]

This will almost certainly be due to shell escaping. I suggest we explore storing the root password in a .mylogin.cnf.

[AdityaMisra]

Can I work on this?