[BUG] mysql cluster create error: chown: invalid user: 'mysql:root'

[JashBook]

Describe the bug

kbcli version
Kubernetes: v1.27.11-gke.1062003
KubeBlocks: 0.8.3-beta.20
kbcli: 0.8.3-beta.17

To Reproduce Steps to reproduce the behavior:

1. create cluster

kbcli cluster create  asmysql-jnkrqy --termination-policy=Delete --monitoring-interval=0 --cluster-definition=mysql --enable-all-logs=false --cluster-version=mysql-8.0.33 --set cpu=100m,memory=0.5Gi,replicas=2,storage=10Gi  --namespace ns-pewnvjkgsz

2. See error

kubectl get pod -A  
ns-pewnvjkgsz   asmysql-jnkrqy-mysql-0                                           0/4     Init:CrashLoopBackOff   5 (112s ago)    5m14s
ns-pewnvjkgsz   asmysql-jnkrqy-mysql-1                                           0/4     Init:CrashLoopBackOff   5 (115s ago)    5m13s

logs pod

kubectl logs -n ns-pewnvjkgsz   asmysql-jnkrqy-mysql-0 init-data
chown: invalid user: 'mysql:root'

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Additional context Add any other context about the problem here.

[ahjing99]

still failed on 0.8.3-beta.22 https://github.com/apecloud/kubeblocks/actions/runs/9092541314/job/24990427097

[JashBook]

kbcli version
Kubernetes: v1.28.7-gke.1026000
KubeBlocks: 0.8.3-beta.22
kbcli: 0.8.3-beta.17

mysql-5.7.42 crash

kubectl get pod -l app.kubernetes.io/instance=asmysql-rtxgea
NAME                     READY   STATUS             RESTARTS        AGE
asmysql-rtxgea-mysql-0   2/3     CrashLoopBackOff   6 (3m5s ago)    9m34s
asmysql-rtxgea-mysql-1   2/3     CrashLoopBackOff   6 (3m15s ago)   9m33s

log pod

kubectl logs asmysql-rtxgea-mysql-0  mysql
mv: cannot stat '/var/lib/mysql/plugin/audit_log.so': No such file or directory
bash: line 7: /scripts/docker-entrypoint.sh: No such file or directory

kubectl logs asmysql-rtxgea-mysql-1 mysql 
mv: cannot stat '/var/lib/mysql/plugin/audit_log.so': No such file or directory
bash: line 7: /scripts/docker-entrypoint.sh: No such file or directory

[JashBook]

not found backuppolicy

kubectl get cluster
NAME             CLUSTER-DEFINITION   VERSION        TERMINATION-POLICY   STATUS    AGE
asmysql-esebde   mysql                mysql-5.7.42   Halt                 Running   25m
asmysql-kamruu   mysql                mysql-8.0.33   DoNotTerminate       Running   25m

kubectl get backuppolicy
No resources found in default namespace.

2024-05-15T12:46:37.885Z	ERROR	Reconciler error	{"controller": "component", "controllerGroup": "apps.kubeblocks.io", "controllerKind": "Component", "Component": {"name":"asmysql-kamruu-mysql","namespace":"default"}, "namespace": "default", "name": "asmysql-kamruu-mysql", "reconcileID": "7f670ba8-1056-4042-b467-d483a8ed5dfe", "error": "not found any backup policy created by mysql-hscale-backup-policy-template"}
sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).reconcileHandler
	/go/pkg/mod/sigs.k8s.io/[email protected]/pkg/internal/controller/controller.go:324
sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).processNextWorkItem
	/go/pkg/mod/sigs.k8s.io/[email protected]/pkg/internal/controller/controller.go:265
sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).Start.func2.2
	/go/pkg/mod/sigs.k8s.io/[email protected]/pkg/internal/controller/controller.go:226
2024-05-15T12:46:38.042Z	INFO	not found any backup policy created by mysql-hscale-backup-policy-template	{"controller": "component", "controllerGroup": "apps.kubeblocks.io", "controllerKind": "Component", "Component": {"name":"asmysql-kamruu-mysql","namespace":"default"}, "namespace": "default", "name": "asmysql-kamruu-mysql", "reconcileID": "4ffb2003-da53-4b20-beeb-911255cc5b97", "component": {"name":"asmysql-kamruu-mysql","namespace":"default"}}
2024-05-15T12:46:38.042Z	ERROR	Reconciler error	{"controller": "component", "controllerGroup": "apps.kubeblocks.io", "controllerKind": "Component", "Component": {"name":"asmysql-kamruu-mysql","namespace":"default"}, "namespace": "default", "name": "asmysql-kamruu-mysql", "reconcileID": "4ffb2003-da53-4b20-beeb-911255cc5b97", "error": "not found any backup policy created by mysql-hscale-backup-policy-template"}
sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).reconcileHandler
	/go/pkg/mod/sigs.k8s.io/[email protected]/pkg/internal/controller/controller.go:324
sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).processNextWorkItem
	/go/pkg/mod/sigs.k8s.io/[email protected]/pkg/internal/controller/controller.go:265
sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).Start.func2.2
	/go/pkg/mod/sigs.k8s.io/[email protected]/pkg/internal/controller/controller.go:226