You need to specify one of MYSQL_ROOT_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD and MYSQL_RANDOM_ROOT_PASSWORD

[bongmu]

apiVersion: mysql.radondb.com/v1alpha1
kind: MysqlCluster
metadata:
name: mysql
namespace: uat
spec:
replicas: 2
mysqlVersion: "5.7"
mysqlOpts:
rootPassword: "dasfdasmk1"
rootHost: localhost
user: radondb_usr
password: RadonDB@123
database: radondb
initTokuDB: false

Create MysqlCluster error：

2022-08-15T10:26:43.717189615+08:00 error: database is uninitialized and password option is not specified

2022-08-15T10:26:43.717223701+08:00 You need to specify one of MYSQL_ROOT_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD and MYSQL_RANDOM_ROOT_PASSWORD

[github-actions]

Hi! thanks for your contribution! great first issue!

[runkecheng]

check the env

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'

[bongmu]

check the env

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'

ENV
[map[name:MYSQL_ALLOW_EMPTY_PASSWORD value:yes] map[name:MYSQL_ROOT_HOST value:localhost] map[name:MYSQL_INIT_ONLY value:1] map[name:MYSQL_ROOT_PASSWORD valueFrom:map[secretKeyRef:map[key:root-password name:mysql-secret optional:false]]]]

[runkecheng]

check the env

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'

ENV [map[name:MYSQL_ALLOW_EMPTY_PASSWORD value:yes] map[name:MYSQL_ROOT_HOST value:localhost] map[name:MYSQL_INIT_ONLY value:1] map[name:MYSQL_ROOT_PASSWORD valueFrom:map[secretKeyRef:map[key:root-password name:mysql-secret optional:false]]]]

env looks no problem，may be your password do not meet the specifications(^[A-Za-z0-9@#$%^&*_+\-=]{8,32}$)

[bongmu]

check the env

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'
ENV [map[name:MYSQL_ALLOW_EMPTY_PASSWORD value:yes] map[name:MYSQL_ROOT_HOST value:localhost] map[name:MYSQL_INIT_ONLY value:1] map[name:MYSQL_ROOT_PASSWORD valueFrom:map[secretKeyRef:map[key:root-password name:mysql-secret optional:false]]]]

env looks no problem，may be your password do not meet the specifications(^[A-Za-z0-9@#$%^&*_+-=]{8,32}$)

No, I tried a more complex password 7X^c29y&QyeuwQLXeW
still that error

[runkecheng]

check the env

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'
ENV [map[name:MYSQL_ALLOW_EMPTY_PASSWORD value:yes] map[name:MYSQL_ROOT_HOST value:localhost] map[name:MYSQL_INIT_ONLY value:1] map[name:MYSQL_ROOT_PASSWORD valueFrom:map[secretKeyRef:map[key:root-password name:mysql-secret optional:false]]]]

env looks no problem，may be your password do not meet the specifications(^[A-Za-z0-9@#$%^&*_+-=]{8,32}$)

No, I tried a more complex password 7X^c29y&QyeuwQLXeW still that error

After modifying the password, you need to delete the POD and PVCs that have been created.

[bongmu]

检查环境

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'

kubectl get po mysql-mysql-0 -n uat -o custom-columns='ENV:.spec.initContainers[1].env'
ENV [map[name:MYSQL_ALLOW_EMPTY_PASSWORD value:yes] map[name:MYSQL_ROOT_HOST value:localhost] map[name:MYSQL_INIT_ONLY value:1] map[name:MYSQL_ROOT_PASSWORD valueFrom:map[secretKeyRef:map[key:root-password name:mysql-secret optional:false]]]]

env看起来没问题，可能是你的密码不符合规范(^[A-Za-z0-9@#$%^&*_+-=]{8,32}$)

不，我尝试了更复杂的密码 7X^c29y&QyeuwQLXeW 仍然是那个错误

修改密码后，需要删除已创建的POD和PVC。

yes, I follow the delete and create steps to recreate, but it is still an error

[bongmu]

The following errors were found in the init-mysql container

[bongmu]

The following errors were found in the init-mysql container

[zhl003]

please check :

 kubectl get pods  -o jsonpath="{.items[*].spec.containers[*].image}"

kubectl get cm  sample-mysql -o yaml

[acekingke]

check the config innodb_use_native_aio whether exist.

[bongmu]

check the config innodb_use_native_aio whether exist.

kubectl get cm mysql-mysql -n uat -o yaml|grep innodb_use_native_aio
innodb_use_native_aio = 1

it exists

[acekingke]

which version of the operator? it should not exist the innodb_use_native_aio = 1 in new version.

[bongmu]

which version of the operator? it should not exist the innodb_use_native_aio = 1 in new version.

mysql-operator-2.2.0